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

SQL Tuning Health-Check Script (SQLHC) (文档 ID 1366133.1)For Example: # sqlplus / as sysdbaSQL> START sqlhc.sql T djkbyr8vkc64h

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

版权声明:本文内容由互联网用户自发贡献,该文观点仅代表作者本人。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容, 请发送邮件至 举报,一经查实,本站将立刻删除。
转载请注明出处: https://daima100.com/10370.html

上一篇 2022-12-28
下一篇 2022-12-28



您的电子邮箱地址不会被公开。 必填项已用*标注