21.Oracle杂记——Oracle报告类脚本

报告类主要输出ORACLE数据块相关的各种报告。

执行如下：

[oracle@OEL dbmon_v0.1]$ sh dbreport.sh

Invalid Arguments!

pls use like this : ./dbreport.exe [ NUMBER]

the NUMBER can be from 1 to 100

[1] get awr report

[2] get ash report

[3] get addm report

[4] get rac awr report

[5] get one instance of rac awr report

[6] get many instances of rac awr report

[7] get sql report

[8] get sql report at specified instance

[9] get awr diff report

[10] get rac's awr diff report

[11] get specified instance's awr diff report

[12} get rac's one or many instances's awr diff report

[13] get ash of RAC's instance report

[14] get addm of RAC's instance report

[15] get awr's information

获取各种报告，蛤蟆在程序中将报告的种类已经讲得很清楚了。

包括AWR,ADDM,ASH,sql， RAC的AWR报告，AWR对比报告等。

程序名字如下：dbreport.exe

下载地址： http://download.csdn.net/detail/notbaron/9447082