{"id":45037,"date":"2025-06-22T02:22:57","date_gmt":"2025-06-21T18:22:57","guid":{"rendered":"https:\/\/www.wsisp.com\/helps\/45037.html"},"modified":"2025-06-22T02:22:57","modified_gmt":"2025-06-21T18:22:57","slug":"53-oracle-sqlhc%e5%a4%9a%e7%89%88%e6%9c%ac%e5%ae%9e%e6%93%8d%e5%90%ab23-ai","status":"publish","type":"post","link":"https:\/\/www.wsisp.com\/helps\/45037.html","title":{"rendered":"53-Oracle sqlhc\u591a\u7248\u672c\u5b9e\u64cd\u542b(23 ai)"},"content":{"rendered":"

SQLHC（SQL Health Check）\u4f5c\u4e3a Oracle \u6570\u636e\u5e93\u6027\u80fd\u8bca\u65ad\u7684\u6838\u5fc3\u5de5\u5177，\u5176\u8bbe\u8ba1\u7406\u5ff5\u548c\u6838\u5fc3\u529f\u80fd\u5728 Oracle \u5404\u7248\u672c\u4e2d\u4fdd\u6301\u9ad8\u5ea6\u4e00\u81f4，\u4f46\u5728\u6280\u672f\u5b9e\u73b0\u548c\u5468\u8fb9\u751f\u6001\u4e0a\u5b58\u5728\u6e10\u8fdb\u5f0f\u4f18\u5316\u3002\u5b9a\u671f\u5bf9\u5173\u952e\u4e1a\u52a1 SQL \u6267\u884c\u5065\u5eb7\u68c0\u67e5，\u7279\u522b\u662f\u5728\u7248\u672c\u5347\u7ea7\u6216\u7edf\u8ba1\u4fe1\u606f\u53d8\u66f4\u540e\u3002<\/p>\n

\u4e00\u3001SQLHC（SQL Tuning Health-Check Script）\u7684\u529f\u80fd\u548c\u6280\u672f<\/h4>\n

1. \u529f\u80fd：<\/h5>\n

SQLHC（SQL Tuning Health-Check Script）\u662fOracle\u63d0\u4f9b\u7684\u4e00\u4e2a\u7528\u4e8e\u68c0\u67e5\u5355\u4e2aSQL\u8bed\u53e5\u8fd0\u884c\u73af\u5883\u7684\u5065\u5eb7\u68c0\u67e5\u5de5\u5177\u3002\u5b83\u6536\u96c6\u4e0eSQL\u6027\u80fd\u76f8\u5173\u7684\u5404\u79cd\u4fe1\u606f，\u8bca\u65adSQL\u6027\u80fd\u95ee\u9898\u3002 <\/p>\n

  • \u88ab\u5206\u6790\u7684SQL\u8bed\u53e5\u8bbf\u95ee\u7684\u6a21\u5f0f\u5bf9\u8c61\u7684CBO\u7edf\u8ba1\u4fe1\u606f\u3002<\/li>\n
  • CBO\u53c2\u6570\u3002<\/li>\n
  • CBO\u7cfb\u7edf\u7edf\u8ba1\u3002<\/li>\n
  • CBO\u6570\u636e\u5b57\u5178\u7edf\u8ba1\u3002<\/li>\n
  • CBO\u56fa\u5b9a\u5bf9\u8c61\u7edf\u8ba1\u3002<\/li>\n
    2. \u6280\u672f\u539f\u7406：<\/h5>\n
  • \u6536\u96c6\u73af\u5883\u4fe1\u606f：SQLHC\u901a\u8fc7\u67e5\u8be2\u6570\u636e\u5b57\u5178\u548c\u52a8\u6001\u6027\u80fd\u89c6\u56fe，\u6536\u96c6\u4e0eSQL\u6267\u884c\u76f8\u5173\u7684\u73af\u5883\u4fe1\u606f，\u5305\u62ec\u6570\u636e\u5e93\u7248\u672c\u3001\u53c2\u6570\u8bbe\u7f6e\u3001\u7cfb\u7edf\u7edf\u8ba1\u4fe1\u606f\u7b49\u3002<\/li>\n
  • \u5206\u6790SQL\u6267\u884c\u8ba1\u5212：\u83b7\u53d6\u6307\u5b9aSQL_ID\u7684\u6267\u884c\u8ba1\u5212，\u5e76\u5206\u6790\u5176\u6267\u884c\u8ba1\u5212\u662f\u5426\u5408\u7406，\u662f\u5426\u5b58\u5728\u6027\u80fd\u95ee\u9898\u3002<\/li>\n
  • \u68c0\u67e5\u7edf\u8ba1\u4fe1\u606f：\u9a8c\u8bc1\u76f8\u5173\u8868\u3001\u7d22\u5f15\u3001\u5217\u7684\u7edf\u8ba1\u4fe1\u606f\u662f\u5426\u6700\u65b0\u548c\u51c6\u786e，\u4ee5\u53ca\u662f\u5426\u5b58\u5728\u7f3a\u5931\u6216\u8fc7\u65f6\u7684\u7edf\u8ba1\u4fe1\u606f\u3002<\/li>\n
  • \u68c0\u67e5\u53c2\u6570\u8bbe\u7f6e：\u9a8c\u8bc1\u5f71\u54cd\u4f18\u5316\u5668\u884c\u4e3a\u7684\u53c2\u6570\u8bbe\u7f6e\u662f\u5426\u5408\u7406，\u5982optimizer_mode\u3001optimizer_index_cost_adj\u7b49\u3002<\/li>\n
  • \u751f\u6210\u62a5\u544a：\u5c06\u6536\u96c6\u7684\u4fe1\u606f\u548c\u5206\u6790\u7ed3\u679c\u6c47\u603b\u751f\u6210HTML\u62a5\u544a，\u4fbf\u4e8e\u7528\u6237\u67e5\u770b\u3002<\/li>\n
    3. \u62a5\u544a\u89e3\u6790<\/span><\/span>\u200b<\/span><\/span><\/h5>\n

    \u901a\u8fc7\u52a8\u6001\u91c7\u96c6\u4ee5\u4e0b\u5173\u952e\u6570\u636e\u751f\u6210 HTML \u62a5\u544a：<\/span><\/span> <\/p>\n

    \u5173\u952e\u6280\u672f\u70b9\u200b： <\/p>\n

      \n
    • \u200b\u8bca\u65ad\u5305\u96c6\u6210\u200b：\u5f53\u542f\u7528 Tuning Pack \u6216 Diagnostics Pack \u65f6，\u81ea\u52a8\u6574\u5408 AWR\/ASH \u6570\u636e<\/li>\n
    • \u200b\u52a8\u6001\u91c7\u6837\u200b：\u5b9e\u65f6\u83b7\u53d6\u6267\u884c\u8ba1\u5212\u300110053 \u8ddf\u8e2a\u6587\u4ef6<\/li>\n
    • \u200b\u73af\u5883\u5feb\u7167\u200b：\u8bb0\u5f55 SQL \u8fd0\u884c\u65f6\u7684\u6570\u636e\u5e93\u914d\u7f6e\u72b6\u6001<\/li>\n<\/ul>\n

      \u4e8c\u3001SQLHC \u5728 Oracle \u5404\u7248\u672c\u4e2d\u7684\u6f14\u8fdb<\/h4>\n

      \u7248\u672c \u6f14\u8fdb\u91cd\u70b9 \u6280\u672f\u7279\u70b9 \u517c\u5bb9\u6027\u8bf4\u660e<\/p>\n

      Oracle 10g \u521d\u59cb\u7248\u672c\u53d1\u5e03 \u57fa\u4e8e SQL \u811a\u672c\u96c6（"sqlhc.sql"），\u65e0\u6570\u636e\u5e93\u75d5\u8ff9（Rollback \u673a\u5236） \u4ec5\u652f\u6301 10g+（\u4f9d\u8d56 SQL_ID \u673a\u5236）<\/p>\n

      Oracle 11g\/12c \u589e\u5f3a AWR \u96c6\u6210 \u652f\u6301\u8bca\u65ad\u5305（Diagnostics Pack）\u83b7\u53d6\u5386\u53f2\u6267\u884c\u8ba1\u5212，\u4f18\u5316\u7edf\u8ba1\u4fe1\u606f\u6536\u96c6\u903b\u8f91 \u811a\u672c\u901a\u7528，\u65e0\u7248\u672c\u5dee\u5f02<\/p>\n

      Oracle 19c \u5bb9\u5668\u6570\u636e\u5e93（CDB\/PDB）\u652f\u6301 \u53ef\u9488\u5bf9 PDB \u8fd0\u884c，\u8f93\u51fa\u62a5\u544a\u5305\u542b\u591a\u79df\u6237\u73af\u5883\u4fe1\u606f \u811a\u672c\u4e0e 11g\/12c \u5b8c\u5168\u76f8\u540c<\/p>\n

      Oracle 23ai \u751f\u6001\u5de5\u5177\u5347\u7ea7\u6838\u5fc3 SQLHC\u8fdb\u5316，23ai \u5168\u7cfb\u5217\u7248\u672c\u517c\u5bb9，\u9002\u914d23ai\u65b0\u7279\u6027，\u4ecd\u662f\u5b98\u65b9\u63a8\u8350\u7684SQL\u8bca\u65ad\u5de5\u5177<\/p>\n

      \u4e09\u3001\u5404\u7248\u672c\u5b9e\u64cd<\/h4>\n

      1. \u901a\u7528 SQLHC \u8bca\u65ad（\u5168\u7248\u672c\u9002\u7528）<\/h5>\n

      # \u4e0b\u8f7d\u811a\u672c\u5e76\u89e3\u538b unzip sqlhc.zip ，sql\u4e2d\u8bb0\u5f97\u627e\u5230\u5bf9\u5e94\u7684\u8def\u5f84<\/p>\n

      \u00a02. \u4f7f\u7528\u6b65\u9aa4\u200b<\/p>\n

      –\u89e3\u538b\u7f29
      \n unzip sqlhc.zip
      \n[oracle@rac11 ~]$ ls -lrht
      \ntotal 2.0M
      \n-rw-r–r– 1 oracle oinstall 2.6K Sep 19 2024 tbs.sql
      \n-rw-r–r– 1 oracle oinstall 263 Sep 26 2024 history.log
      \n-rw-r–r– 1 oracle oinstall 34 Oct 10 2024 wyxx.j
      \ndr-xr-xr-x 3 oracle oinstall 4.0K Feb 23 17:01 sqlhc
      \n-rw-r–r– 1 oracle oinstall 1.5M Jun 19 20:49 pdbrs6-20250619-7-9AM.html
      \n-rw-r–r– 1 oracle oinstall 83K Jun 20 10:45 RAC-PDBRS6-20250620.txt
      \n-rw-r–r– 1 root root 223K Jun 20 17:21 sqlhc.zip
      \n-rw-r–r– 1 root root 171K Jun 20 17:21 sqlhc11g.zip
      \n[oracle@rac11 ~]$ cd sqlhc\/
      \n[oracle@rac11 sqlhc]$ pwd
      \n\/home\/oracle\/sqlhc
      \n[oracle@rac11 sqlhc]$ ls -lrht
      \ntotal 880K
      \n-rw-r–r– 1 oracle oinstall 545 Oct 9 2024 sqlhc_pxhcdr_null.sql
      \n-rw-r–r– 1 oracle oinstall 2.3K Oct 9 2024 sqlhc_tcb.sql
      \n-rw-r–r– 1 oracle oinstall 48K Oct 10 2024 sqldx.sql
      \n-rw-r–r– 1 oracle oinstall 510 Oct 10 2024 sqlhc_db_null.sql
      \n-rw-r–r– 1 oracle oinstall 328K Oct 10 2024 sqlhc_db.sql
      \n-rw-r–r– 1 oracle oinstall 491 Oct 10 2024 sqlhc_exit.sql
      \n-rw-r–r– 1 oracle oinstall 75K Oct 10 2024 sqlhc_pxhcdr.sql
      \n-rw-r–r– 1 oracle oinstall 4.4K Oct 10 2024 sqlhc_sta.sql
      \n-rw-r–r– 1 oracle oinstall 60K Oct 10 2024 util_planx.sql
      \ndr-xr-xr-x 4 oracle oinstall 4.0K Feb 23 17:00 utl
      \n-rw-r–r– 1 oracle oinstall 337K Feb 23 17:03 sqlhc.sql
      \n—
      \n— \u4ee5DBA\u8eab\u4efd\u8fde\u63a5
      \nsqlplus \/ as sysdba<\/p>\n

      — \u6267\u884cSQLHC\u811a\u672c（\u9700\u63d0\u524d\u4e0b\u8f7d\u89e3\u538b）
      \nSTART \/path\/to\/sqlhc.sql "T" <SQL_ID> <\/p>\n

      \u53c2\u6570\u8bf4\u660e\u200b：<\/p>\n

    • \u00a0"T"：\u542f\u7528Tuning Pack（\u542bDiagnostics）<\/li>\n
    • \u00a0"D"：\u4ec5\u542f\u7528Diagnostics Pack<\/li>\n
    • \u00a0"N"：\u65e0\u8bb8\u53ef\u5305<\/li>\n
    • \u00a0：\u76ee\u6807SQL\u7684ID（\u4eceV$SQL\u6216AWR\u62a5\u544a\u4e2d\u83b7\u53d6）<\/li>\n
      2.\u9ed8\u8ba4\u662f\u5df2\u7ecf\u5f00\u542f\u4e86awr\u7684\u6536\u96c6，\u5982\u65e0\u8bf7\u5f00\u542f<\/h5>\n

      \u624b\u52a8\u751f\u6210AWR\u5feb\u7167,AWR\u62a5\u544a\u4e2d\u7684sql id\u9700\u8981\u4f7f\u7528<\/p>\n

      EXEC DBMS_WORKLOAD_REPOSITORY.CREATE_SNAPSHOT();
      \n—
      \n–\u67e5\u8be2\u6570\u636e
      \nSELECT \/* SQLHC_20250620*\/ * from his50.tbl_Clinic where 1=1 order by dRegisterDate;
      \n—
      \n00000003021657391315 0000000302 \u59dc** 1 53 20-JUN-25 20-JUN-25 5301 0
      \n170606 20250620000514 \u5b59** 1 32 20-JUN-25 20-JUN-25 MR MR 0
      \n170713 20250620000515 \u6768** 1 67 20-JUN-25 20-JUN-25 MR MR 0
      \n170747 20250620000516 \u6768** 1 67 20-JUN-25 20-JUN-25 MR MR 0<\/p>\n

      1,472 rows selected.
      \n–\u518d\u6b21\u6536\u96c6awr
      \nEXEC DBMS_WORKLOAD_REPOSITORY.CREATE_SNAPSHOT();
      \n–\u627e\u5bfbSQL_ID
      \nSELECT sql_id, plan_hash_value, substr(sql_text,1,40) sql_text
      \nFROM v$sql
      \nWHERE sql_text like 'SELECT \/* SQLHC_20250620*\/%';<\/p>\n

      SQL> SELECT sql_id, plan_hash_value, substr(sql_text,1,40) sql_text
      \n 2 FROM v$sql
      \n 3* WHERE sql_text like 'SELECT \/* SQLHC_20250620*\/%';<\/p>\n

      SQL_ID PLAN_HASH_VALUE SQL_TEXT
      \n________________ __________________ ___________________________________________
      \n78mdr2csmpkrr 1293871107 SELECT \/* SQLHC_20250620*\/ * from his50. <\/p>\n

      \u00a03. Oracle 11g\u200b\/19C<\/h5>\n

      — \u4f7f\u7528\u793a\u4f8b\u4e2d\u7684SQL_ID 78mdr2csmpkrr
      \n–START \/home\/oracle\/sqlhc.sql "T" <SQL_ID>
      \nSTART \/home\/oracle\/sqlhc\/sqlhc.sql "T" 78mdr2csmpkrr
      \n—
      \nArchive: sqlhc_20250620_1728_78mdr2csmpkrr.zip <\/p>\n

      \"\"<\/p>\n

      4. 23ai<\/h5>\n

      Connected to:
      \nOracle Database 23ai Free Release 23.0.0.0.0 – Develop, Learn, and Run for Free
      \nVersion 23.8.0.25.04<\/p>\n

      SYS@FREE> @\/home\/oracle\/sqlhc\/sqlhc.sql "T" 0npm6czzaj44m<\/p>\n

      Parameter 1:
      \nOracle Pack License (Tuning, Diagnostics or None) [T|D|N] (required)<\/p>\n

      PL\/SQL procedure successfully completed.<\/p>\n

      Parameter 2:
      \nSQL_ID of the SQL to be analyzed (required) or press RETURN to get
      \nDB only mode (only non-SQL_ID report).<\/p>\n

      PL\/SQL procedure successfully completed.<\/p>\n

      DB_SCRIPT
      \n————————————————————————————————————————
      \nsqlhc_db_null.sql<\/p>\n

      Session altered.<\/p>\n

      Running in SQL_ID mode<\/p>\n

      Session altered.<\/p>\n

      INPUT_SQL_ID
      \n————-
      \n0npm6czzaj44m<\/p>\n

      Values passed:
      \nLicense: "T"
      \nMode : "SQL ID mode"
      \nSQL_ID : "0npm6czzaj44m"<\/p>\n

      DBID
      \n———-
      \n1475650002<\/p>\n

      SQL_ID
      \n————-
      \n0npm6czzaj44m<\/p>\n

      PL\/SQL procedure successfully completed.<\/p>\n

      PL\/SQL procedure successfully completed.<\/p>\n

      SYS@FREE>
      \nSYS@FREE> \/**************************************************************************************************
      \nSYS@FREE> *
      \nSYS@FREE> * begin_common: from begin_common to end_common sqlhc.sql and sqlhcxec.sql are identical
      \nSYS@FREE> *
      \nSYS@FREE> **************************************************************************************************\/
      \nSYS@FREE> SELECT 'BEGIN: '||TO_CHAR(SYSDATE, 'YYYY-MM-DD\/HH24:MI:SS') FROM dual;<\/p>\n

      'BEGIN:'||TO_CHAR(SYSDATE,<\/p>\n

      \u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026<\/p>\n

      adding: sqlhc_20250620_1820_0npm6czzaj44m_2_startup_history.txt (deflated 55%)<\/p>\n

      Parameter 1:
      \nOracle Pack License (Tuning or Diagnostics) [T|D] (required)<\/p>\n

      Parameter 2:
      \nOutput Type (HTML or CSV or Both) [H|C|B] (required)<\/p>\n

      Parameter 3:
      \nSQL_ID of the SQL to be analyzed (required)<\/p>\n

      Values passed:
      \nLicense: "T"
      \nOutput : "CSV"
      \nSQL_ID : "0npm6czzaj44m"<\/p>\n

      ### … getting SQL text …<\/p>\n

      ### … getting signature …<\/p>\n

      ### … getting tables …<\/p>\n

      ### … generating dynamic script, please wait …<\/p>\n

      Session altered.<\/p>\n

      adding: sqlhc_20250620_1820_0npm6czzaj44m_8_sqldx.zip (stored 0%)<\/p>\n

      SQLDX files have been added to sqlhc_20250620_1820_0npm6czzaj44m.zip<\/p>\n

      Archive: sqlhc_20250620_1820_0npm6czzaj44m.zip
      \n Length Date Time Name
      \n——— ———- —– —-
      \n 951447 06-20-2025 18:23 sqlhc_20250620_1820_0npm6czzaj44m_1_main.html
      \n 11946 06-20-2025 18:23 sqlhc_20250620_1820_0npm6czzaj44m_3_execution_plans.html
      \n 16311 06-20-2025 18:23 sqlhc_20250620_1820_0npm6czzaj44m_4_sql_detail.html
      \n 26361 06-20-2025 18:23 sqlhc_20250620_1820_0npm6czzaj44m_9_log.zip
      \n 1326 06-20-2025 18:23 sqlhc_20250620_1820_0npm6czzaj44m_10_sql_tuning_advisor.out
      \n 178280 06-20-2025 18:23 sqlhc_20250620_1820_0npm6czzaj44m_6_10053_trace_from_cursor.trc
      \n 574 06-20-2025 18:24 sqlhc_20250620_1820_0npm6czzaj44m_11_tcb.zip
      \n 438049 06-20-2025 18:25 sqlhc_20250620_1820_0npm6czzaj44m_12_awr.zip
      \n 3213 06-20-2025 18:25 sqlhc_20250620_1820_0npm6czzaj44m_7_driver.zip
      \n 147 06-20-2025 18:23 sqlhc_20250620_1820_0npm6czzaj44m_2_startup_history.txt
      \n 351816 06-20-2025 18:26 sqlhc_20250620_1820_0npm6czzaj44m_8_sqldx.zip
      \n——— ——-
      \n 1979470 11 files<\/p>\n

      SQL> <\/p>\n

      <\/h4>\n

      \"\"<\/p>\n

      \u56db\u3001sqlhc\u6ce8\u610f\u4e8b\u9879\u200b<\/h4>\n

      SQL_ID\u9650\u5236\u200b：<\/p>\n

        \n
      • \u4e0d\u652f\u6301PL\/SQL\u5305\u5185\u7684SQL\u3002<\/li>\n
      • \u4e00\u6b21\u4ec5\u80fd\u5206\u6790\u4e00\u4e2aSQL_ID\u3002<\/li>\n<\/ul>\n

        \u8bb8\u53ef\u8981\u6c42\u200b：<\/p>\n

          \n
        • Tuning\/Diagnostics Pack\u975e\u5fc5\u9700，\u4f46\u542f\u7528\u540e\u53ef\u83b7\u53d6AWR\u6df1\u5ea6\u5206\u6790\u3002<\/li>\n<\/ul>\n

          \u200b\u524d\u7f6e\u6761\u4ef6\u200b：<\/p>\n

            \n
          • \u9700\u5728SQL\u6267\u884c\u524d\u540e\u751f\u6210AWR\u5feb\u7167（\u5426\u5219\u62a5\u544a\u65e0\u6570\u636e）：<\/li>\n<\/ul>\n

            EXEC DBMS_WORKLOAD_REPOSITORY.CREATE_SNAPSHOT(); <\/p>\n

            \u8f93\u51fa\u89e3\u8bfb\u200b：<\/p>\n

              \n
            • \u62a5\u544a\u6587\u4ef6\u547d\u540d：sqlhc_<\u65e5\u671f>_<\u65f6\u95f4>_.zip<\/li>\n
            • \u6838\u5fc3\u6587\u4ef6：*_main.html（\u6c47\u603b\u95ee\u9898\u4e0e\u5efa\u8bae）<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"

              \u6587\u7ae0\u6d4f\u89c8\u9605\u8bfb653\u6b21\uff0c\u70b9\u8d5e11\u6b21\uff0c\u6536\u85cf18\u6b21\u3002SQLHC\uff08SQL Health Check\uff09\u4f5c\u4e3a Oracle \u6570\u636e\u5e93\u6027\u80fd\u8bca\u65ad\u7684\u6838\u5fc3\u5de5\u5177\uff0c\u5176\u8bbe\u8ba1\u7406\u5ff5\u548c\u6838\u5fc3\u529f\u80fd\u5728 Oracle \u5404\u7248\u672c\u4e2d\u4fdd\u6301\u9ad8\u5ea6\u4e00\u81f4\uff0c\u4f46\u5728\u6280\u672f\u5b9e\u73b0\u548c\u5468\u8fb9\u751f\u6001\u4e0a\u5b58\u5728\u6e10\u8fdb\u5f0f\u4f18\u5316\u3002\u5b9a\u671f\u5bf9\u5173\u952e\u4e1a\u52a1 SQL \u6267\u884c\u5065\u5eb7\u68c0\u67e5\uff0c\u7279\u522b\u662f\u5728\u7248\u672c\u5347\u7ea7\u6216\u7edf\u8ba1\u4fe1\u606f\u53d8\u66f4\u540e\u300223ai \u7528\u6237\u53ef\u4f18\u5148\u91c7\u7528 DBMS_HCHECK \u5b9e\u73b0\u81ea\u52a8\u5316\u5de1\u68c0\uff0c23ai free\u73b0\u572823.8.0.25.04\u8fd8\u662fDBMS_DICTIONARY_CHECK.FULL\u3002<\/p>\n","protected":false},"author":2,"featured_media":45035,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[4142,604,768,323,100],"topic":[],"class_list":["post-45037","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-server","tag-database","tag-oracle","tag-sql","tag-323","tag-100"],"yoast_head":"\n53-Oracle sqlhc\u591a\u7248\u672c\u5b9e\u64cd\u542b(23 ai) - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.wsisp.com\/helps\/45037.html\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"53-Oracle sqlhc\u591a\u7248\u672c\u5b9e\u64cd\u542b(23 ai) - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\" \/>\n<meta property=\"og:description\" content=\"\u6587\u7ae0\u6d4f\u89c8\u9605\u8bfb653\u6b21\uff0c\u70b9\u8d5e11\u6b21\uff0c\u6536\u85cf18\u6b21\u3002SQLHC\uff08SQL Health Check\uff09\u4f5c\u4e3a Oracle \u6570\u636e\u5e93\u6027\u80fd\u8bca\u65ad\u7684\u6838\u5fc3\u5de5\u5177\uff0c\u5176\u8bbe\u8ba1\u7406\u5ff5\u548c\u6838\u5fc3\u529f\u80fd\u5728 Oracle \u5404\u7248\u672c\u4e2d\u4fdd\u6301\u9ad8\u5ea6\u4e00\u81f4\uff0c\u4f46\u5728\u6280\u672f\u5b9e\u73b0\u548c\u5468\u8fb9\u751f\u6001\u4e0a\u5b58\u5728\u6e10\u8fdb\u5f0f\u4f18\u5316\u3002\u5b9a\u671f\u5bf9\u5173\u952e\u4e1a\u52a1 SQL \u6267\u884c\u5065\u5eb7\u68c0\u67e5\uff0c\u7279\u522b\u662f\u5728\u7248\u672c\u5347\u7ea7\u6216\u7edf\u8ba1\u4fe1\u606f\u53d8\u66f4\u540e\u300223ai \u7528\u6237\u53ef\u4f18\u5148\u91c7\u7528 DBMS_HCHECK \u5b9e\u73b0\u81ea\u52a8\u5316\u5de1\u68c0\uff0c23ai free\u73b0\u572823.8.0.25.04\u8fd8\u662fDBMS_DICTIONARY_CHECK.FULL\u3002\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.wsisp.com\/helps\/45037.html\" \/>\n<meta property=\"og:site_name\" content=\"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\" \/>\n<meta property=\"article:published_time\" content=\"2025-06-21T18:22:57+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2025\/06\/20250621182255-6856f87f92217.png\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u4f5c\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 \u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/45037.html\",\"url\":\"https:\/\/www.wsisp.com\/helps\/45037.html\",\"name\":\"53-Oracle sqlhc\u591a\u7248\u672c\u5b9e\u64cd\u542b(23 ai) - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\",\"isPartOf\":{\"@id\":\"https:\/\/www.wsisp.com\/helps\/#website\"},\"datePublished\":\"2025-06-21T18:22:57+00:00\",\"dateModified\":\"2025-06-21T18:22:57+00:00\",\"author\":{\"@id\":\"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.wsisp.com\/helps\/45037.html#breadcrumb\"},\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.wsisp.com\/helps\/45037.html\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/45037.html#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u9996\u9875\",\"item\":\"https:\/\/www.wsisp.com\/helps\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"53-Oracle sqlhc\u591a\u7248\u672c\u5b9e\u64cd\u542b(23 ai)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/#website\",\"url\":\"https:\/\/www.wsisp.com\/helps\/\",\"name\":\"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\",\"description\":\"\u9999\u6e2f\u670d\u52a1\u5668_\u9999\u6e2f\u4e91\u670d\u52a1\u5668\u8d44\u8baf_\u670d\u52a1\u5668\u5e2e\u52a9\u6587\u6863_\u670d\u52a1\u5668\u6559\u7a0b\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.wsisp.com\/helps\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"zh-Hans\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery\",\"contentUrl\":\"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery\",\"caption\":\"admin\"},\"sameAs\":[\"http:\/\/wp.wsisp.com\"],\"url\":\"https:\/\/www.wsisp.com\/helps\/author\/admin\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"53-Oracle sqlhc\u591a\u7248\u672c\u5b9e\u64cd\u542b(23 ai) - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.wsisp.com\/helps\/45037.html","og_locale":"zh_CN","og_type":"article","og_title":"53-Oracle sqlhc\u591a\u7248\u672c\u5b9e\u64cd\u542b(23 ai) - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","og_description":"\u6587\u7ae0\u6d4f\u89c8\u9605\u8bfb653\u6b21\uff0c\u70b9\u8d5e11\u6b21\uff0c\u6536\u85cf18\u6b21\u3002SQLHC\uff08SQL Health Check\uff09\u4f5c\u4e3a Oracle \u6570\u636e\u5e93\u6027\u80fd\u8bca\u65ad\u7684\u6838\u5fc3\u5de5\u5177\uff0c\u5176\u8bbe\u8ba1\u7406\u5ff5\u548c\u6838\u5fc3\u529f\u80fd\u5728 Oracle \u5404\u7248\u672c\u4e2d\u4fdd\u6301\u9ad8\u5ea6\u4e00\u81f4\uff0c\u4f46\u5728\u6280\u672f\u5b9e\u73b0\u548c\u5468\u8fb9\u751f\u6001\u4e0a\u5b58\u5728\u6e10\u8fdb\u5f0f\u4f18\u5316\u3002\u5b9a\u671f\u5bf9\u5173\u952e\u4e1a\u52a1 SQL \u6267\u884c\u5065\u5eb7\u68c0\u67e5\uff0c\u7279\u522b\u662f\u5728\u7248\u672c\u5347\u7ea7\u6216\u7edf\u8ba1\u4fe1\u606f\u53d8\u66f4\u540e\u300223ai \u7528\u6237\u53ef\u4f18\u5148\u91c7\u7528 DBMS_HCHECK \u5b9e\u73b0\u81ea\u52a8\u5316\u5de1\u68c0\uff0c23ai free\u73b0\u572823.8.0.25.04\u8fd8\u662fDBMS_DICTIONARY_CHECK.FULL\u3002","og_url":"https:\/\/www.wsisp.com\/helps\/45037.html","og_site_name":"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","article_published_time":"2025-06-21T18:22:57+00:00","og_image":[{"url":"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2025\/06\/20250621182255-6856f87f92217.png"}],"author":"admin","twitter_card":"summary_large_image","twitter_misc":{"\u4f5c\u8005":"admin","\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4":"5 \u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.wsisp.com\/helps\/45037.html","url":"https:\/\/www.wsisp.com\/helps\/45037.html","name":"53-Oracle sqlhc\u591a\u7248\u672c\u5b9e\u64cd\u542b(23 ai) - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","isPartOf":{"@id":"https:\/\/www.wsisp.com\/helps\/#website"},"datePublished":"2025-06-21T18:22:57+00:00","dateModified":"2025-06-21T18:22:57+00:00","author":{"@id":"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41"},"breadcrumb":{"@id":"https:\/\/www.wsisp.com\/helps\/45037.html#breadcrumb"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.wsisp.com\/helps\/45037.html"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.wsisp.com\/helps\/45037.html#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u9996\u9875","item":"https:\/\/www.wsisp.com\/helps"},{"@type":"ListItem","position":2,"name":"53-Oracle sqlhc\u591a\u7248\u672c\u5b9e\u64cd\u542b(23 ai)"}]},{"@type":"WebSite","@id":"https:\/\/www.wsisp.com\/helps\/#website","url":"https:\/\/www.wsisp.com\/helps\/","name":"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","description":"\u9999\u6e2f\u670d\u52a1\u5668_\u9999\u6e2f\u4e91\u670d\u52a1\u5668\u8d44\u8baf_\u670d\u52a1\u5668\u5e2e\u52a9\u6587\u6863_\u670d\u52a1\u5668\u6559\u7a0b","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.wsisp.com\/helps\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"zh-Hans"},{"@type":"Person","@id":"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41","name":"admin","image":{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/image\/","url":"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery","contentUrl":"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery","caption":"admin"},"sameAs":["http:\/\/wp.wsisp.com"],"url":"https:\/\/www.wsisp.com\/helps\/author\/admin"}]}},"_links":{"self":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/posts\/45037","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/comments?post=45037"}],"version-history":[{"count":0,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/posts\/45037\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/media\/45035"}],"wp:attachment":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/media?parent=45037"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/categories?post=45037"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/tags?post=45037"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/topic?post=45037"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}