• From: Ryan January <rjanuary@xxxxxxxxx>
  • To: Brian.Zelli@xxxxxxxxxxxxxxx
  • Date: Mon, 2 Feb 2015 11:59:05 -0600

Are they looking for a produced AWR report, or the raw data? 

If you're looking for an oracle produced AWR report 
$ORACLE_HOME/rdbms/admin/awrrpt.sql  will allow you to run the report and 
select your snapshot periods
If you're looking for the raw data, it can be pulled from the DBA_HIST% tables 
(Quick google link:

> On Feb 2, 2015, at 11:52 AM, Zelli, Brian <Brian.Zelli@xxxxxxxxxxxxxxx> wrote:
> 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?
> Brian
> 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. 

  • References:
    • AWR
      • From: Zelli, Brian

Other related posts: