欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  IT编程

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

程序员文章站 2022-06-04 18:43:16
For Example: # sqlplus / as sysdbaSQL> START sqlhc.sql T djkbyr8vkc64h ......
  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