Shulou(Shulou.com)06/01 Report--

What is SQLHC? full name: SQL Tuning Health-Check Script is a tool developed by Oracle Server Technologies Center of Expertise. The tool, also known as SQLHC, is used to examine the environment in which a single SQL statement runs, including cost-based optimizer (CBO) statistics, metadata definitions of user objects, configuration parameters, and other factors that may affect the performance of the SQL to be analyzed.

Script information description:

Here) collapse or open here) collapse or open REM # sqlplus / as sysdba

REM SQL > START [path] sqlhc.sql [T | D | N] [SQL_ID]

REM SQL > START sqlhc.sql T 51x6yr9ym5hdc

Execution completion generates a ZIP package with a name similar to the following

Click (here) to collapse or open

Sqlhc_20170716_155643_7b2twsn8vgfsc.zip

There is health check, diagnosis, sql execution plan and other related information in HTML format, as well as some logs. If you are interested, you can try the following by yourself.

Refer to the following articles:

SQL Tuning Health-Check Script (SQLHC) (Doc ID 1366133.1)

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.