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 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