oracle 蛤蟆,21.蛤蟆的Oracle杂记——Oracle报告类脚本

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 awrreport

[7] get sql report

[ 8] get sql report at specifiedinstance

[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