当前位置： 移动技术网 > IT编程>数据库>Oracle > SQL Tuning Health-Check Script (SQLHC) (文档 ID 1366133.1)

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

2019年12月27日  | 移动技术网IT编程  | 我要评论

小时代3 票房,牧场物语3,夫妻相测试

  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

您可能感兴趣的文章:

如对本文有疑问，请在下面进行留言讨论，广大热心网友会与你互动！！ 点击进行留言回复

相关文章:

验证码：
最近更新的文章
大家感兴趣的文章
移动技术网