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://www.cnblogs.com/oracle-ziyuhou/p/12103251.html

标签： oracle数据库 orcale开发 oracle技术文章
你还没有登录，请先登录或注册！
  • 还没有人评论，欢迎说说您的想法！