SQLTuningHealthCheckScript(SQLHC)(文档ID1366133.1)

  • Z时代
  • 2024-01-10
  • 分类：综合

database

  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

以上是 SQLTuningHealthCheckScript(SQLHC)(文档ID1366133.1) 的全部内容， 来源链接： utcz.com/z/531895.html

回到顶部