• From: Steve Karam <oraclealchemist@xxxxxxxxx>
  • To: "oracle-l (oracle-l@xxxxxxxxxxxxx)" <oracle-l@xxxxxxxxxxxxx>, brian.zelli@xxxxxxxxxxxxxxx
  • Date: Mon, 2 Feb 2015 13:01:32 -0500


sqlplus / as sysdba

Enter the number of days to go back. Then choose the snapshot of midnight the 
morning of the day you need and a snapshot from midnight the next day.

One thing I’d caution about a full day AWR report: the averages can be 
misleading. For example, over the course of a full day your top wait event 
might be CPU Time, but within a specific 2 hour “trouble window” it may have 
been something more pertinent like an I/O wait. Likewise, computed hit ratios 
and other metrics could be even more misguiding than normal. 

I have a presentation you can check out that has some more information on 
misleading/misused metrics:  

PS: You can also check out AWR Diff reports for comparisons if that’s something 
they’re after:

Happy hunting!

Steve Karam
On February 2, 2015 at 12:53:27 PM, Zelli, Brian (brian.zelli@xxxxxxxxxxxxxxx) 

A vendor just asked me to provide a report from AWR from a few days ago on 
their database. 

Ok, it has been 10 years since I last touched AWR. 

I know this sounds lame bit If it is running, how do I get that day’s 
information to the vendor?





This email message may contain legally privileged and/or confidential 
information. If you are not the intended recipient(s), or the employee or agent 
responsible for the delivery of this message to the intended recipient(s), you 
are hereby notified that any disclosure, copying, distribution, or use of this 
email message is prohibited. If you have received this message in error, please 
notify the sender immediately by e-mail and delete this email message from your 
computer. Thank you.
  • Follow-Ups:
  • References:
    • AWR
      • From: Zelli, Brian

Other related posts: