A plain AWR report compares two points in time, but
I want to generate an AWR report that compares two distinct
time periods. For example, I want an AWR report
showing changes between 3:00 PM and 4: PM last Wednesday and
Thursday. How do I get an AWR report that compares two
elapsed time periods?
awrddrpt.sql report is the Automated Workload
Repository Compare Period Report. The awrddrpt.sql script is
located in the $ORACLE_HOME/rdbms/admin directory.
See my notes on
awrddrpt.sql for more details.
For example, is we wanted to compare the period between
3:00 PM-4:00 PM for Wednesday to the same time period on
Thursday, we could use the awrddrpt.sql script.
Specify the First Pair of Begin and End
Enter value for begin_snap: 13747
First Begin Snapshot Id
Enter value for end_snap: 13749
First End Snapshot Id specified: 13748
Second Pair of Begin and End Snapshot Ids
Enter value for begin_snap2: 13915
Second Begin Snapshot
Id specified: 13915
Enter value for end_snap2: 13917
Second End Snapshot Id specified: 13916
Here is an
example of an awrddrpt.sql report showing how two
AWR reports are compared.
Get the Complete
Oracle SQL Tuning Information
The landmark book
SQL Tuning The Definitive Reference" is
filled with valuable information on Oracle SQL Tuning.
This book includes scripts and tools to hypercharge Oracle 11g
performance and you can
for 30% off directly from the publisher.