Re: AWR
- 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:
http://www.nocoug.org/download/2008-08/a-tour-of-the-awr-tables.nocoug-Aug-21-2008.abercrombie.html
<http://www.nocoug.org/download/2008-08/a-tour-of-the-awr-tables.nocoug-Aug-21-2008.abercrombie.html>)
> 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.
Other related posts:
