参考自SQL 性能健康检查脚本 (SQLHC) (Doc ID 1626277.1)
[oracle@ectona highgodir]$ ls -lrt
total 88
drwx------ 2 oracle oinstall 4096 Nov 22 09:47 sqlhc
-rw-r--r-- 1 oracle oinstall 82313 Nov 23 2016 sqlhc.zip
[oracle@ectona highgodir]$ pwd
/home/oracle/highgodir
[oracle@ectona highgodir]$
[oracle@ectona sqlhc]$ ls -rlt
total 620
-rw-r--r-- 1 oracle oinstall 48747 Nov 12 2013 sqldx.sql
-rw-r--r-- 1 oracle oinstall 288298 Apr 16 2014 sqlhc.sql
-rw-r--r-- 1 oracle oinstall 292838 Apr 16 2014 sqlhcxec.sql
[oracle@ectona sqlhc]$ pwd
/home/oracle/highgodir/sqlhc
[oracle@ectona sqlhc]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Tue Nov 22 13:16:13 2016
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
SQL> START sqlhc.sql T 182dfmzhbrv32
**************************经过两分钟左右的时间才生成完毕*********************************
**************************经过两分钟左右的时间才生成完毕**********************************
[oracle@ectona sqlhc]$ pwd
/home/oracle/highgodir/sqlhc
[oracle@ectona sqlhc]$
[oracle@ectona sqlhc]$ ls -lrt
total 784
-rw-r--r-- 1 oracle oinstall 48747 Nov 12 2013 sqldx.sql
-rw-r--r-- 1 oracle oinstall 288298 Apr 16 2014 sqlhc.sql
-rw-r--r-- 1 oracle oinstall 292838 Apr 16 2014 sqlhcxec.sql
-rw-r--r-- 1 oracle oinstall 165555 Nov 22 09:47 sqlhc_20161122_094229_182dfmzhbrv32.zip --->>>>>这个文件就是生成的最终文件包.
[oracle@ectona sqlhc]$