SQL Tuning Health-Check Script (SQLHC) (文檔 ID 1366133.1)

1. Login to the database server and set the environment used by the Database Instance
2. Download the "sqlhc.zip" archive file and extract the contents to a suitable directory/folder
3. Connect into SQL*Plus as SYS, a DBA account, or a user with access to Data Dictionary views and simply execute the "sqlhc.sql" script. It will request to enter two parameters:
   
   
   1. Oracle Pack License (Tuning, Diagnostics or None) [T|D|N] (required)
      If site has both Tuning and Diagnostics licenses then specify T (Oracle Tuning pack includes Oracle Diagnostics)
      
      
   2. A valid SQL_ID for the SQL to be analyzed.  

For Example:

# sqlplus / as sysdba
SQL> START sqlhc.sql T djkbyr8vkc64h