Thursday, June 28, 2012

AWR Reports Types

list from the 11.2.0.2 home ($ORACLE_HOME/rdbms/admin) with (mostly) the one-line description from the start of file. I’ve put the most useful ones in the first list:



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













 

No comments:

Post a Comment