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: firstname.lastname@example.org ; email@example.com
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" wrote:
Why does the addm report have to be run before the awr script?
On Behalf Of Niall Litchfield
Sent: Monday, November 14, 2011 12:35 PM
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" wrote:
Can anyone recommend where I can find some scripts that query the
AWR files ? I would like to generate reports outside of grid control.