Re: awr scripts
- From: "ed lewis" <eglewis71@xxxxxxxxx>
- To: "Niall Litchfield" <niall.litchfield@xxxxxxxxx>, "Paul Harrison" <cure@xxxxxxxxxxxxx>
- Date: Mon, 14 Nov 2011 15:03:23 -0500
Thanks for everyone for their response.
I currently run the awr, addm reports.ash reports
I was looking for scripts to query the awr history tables.
I would like the flexibility of querying the tables,
and gathering the information I need in 1 report,
instead of looking at numerous awr,addm reports.
----- Original Message -----
From: Niall Litchfield
To: Paul Harrison
Cc: eglewis71@xxxxxxxxx ; oracle-l@xxxxxxxxxxxxx
Sent: Monday, November 14, 2011 2:22 PM
Subject: RE: awr scripts
It doesn't have to be, but oracle itself has already done a generally pretty
good job of analysis on the awr data for the period concerned. I'd always read
that first.
On Nov 14, 2011 7:07 PM, "Paul Harrison" <cure@xxxxxxxxxxxxx> wrote:
Why does the addm report have to be run before the awr script?
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Niall Litchfield
Sent: Monday, November 14, 2011 12:35 PM
To: eglewis71@xxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: awr scripts
$ORACLE_HOME/rdbms/admin/awrrpt for a start.. run the addm report from the
same place first though..
On Nov 14, 2011 6:31 PM, "ed lewis" <eglewis71@xxxxxxxxx> wrote:
> Hi,
> Can anyone recommend where I can find some scripts that query the
> AWR files ? I would like to generate reports outside of grid control.
> thanks
> ed
>
> 10.2.0.4- solaris
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
