|
AWRRPT.SQL
|
Basic AWR reports
|
|
AWRSQRPT.SQL
|
Standrad SQL Statement Report
|
|
AWRDDRPT.SQL
|
Period Diff on current Instance
|
|
AWRRPTI.SQL
|
Workload Repository Report Instance (RAC)
|
|
AWRGRPT.SQL
|
AWR GLOBAL Report(RAC)
|
|
AWRGDRPT.SQL
|
AWR GLOBAL DIFF Report (RAC)
|
|
AWRINFO.SQL
|
Script to Output General AWR Information
|
For most people the awrrpt.sql and awrsqrpt.sql are likely to be sufficient, but the “difference between two periods” can be very useful – especially if you do things like regularly forcing an extra snapshot at the start and end of the overnight batch so that you can (when necessary) find the most significant differences in behaviour between the batch runs on two different nights.
If you get into the ‘RAC difference report’ you’ll need a very wide page – and very good eyesight !
There are also a lot of “infrastructure and support” bits – some of the “input” files give you some nice ideas about how you can write your own code to do little jobs like: “run the most recent AWR report automatically”:
awrblmig.sql |
AWR Baseline Migrate |
awrload.sql |
AWR LOAD: load awr from dump file |
awrextr.sql |
AWR Extract |
awrddinp.sql |
Get inputs for diff report |
awrddrpi.sql |
Workload Repository Compare Periods Report |
awrgdinp.sql |
Get inputs for global diff reports |
awrgdrpi.sql |
Workload Repository Global Compare Periods Report |
awrginp.sql |
AWR Global Input |
awrgrpti.sql |
Workload Repository RAC (Global) Report |
awrinpnm.sql |
AWR Input Name |
awrinput.sql |
Get inputs for AWR report |
awrsqrpi.sql |
Workload Repository SQL Report Instance |
There are also a couple of deceptively named files that you might miss in 11.2:
spawrrac.sql |
Server Performance AWR RAC report |
spawrio.sql |
AWR IO Intensity Report |
spadvrpt.sql |
Streams Performance Advisor report |
Enjoy
Thank you
Osama Mustafa
Technology Geek 