Re: awr scripts

From: ed lewis <>
Date: Mon, 14 Nov 2011 15:03:23 -0500
Message-ID: <C0FFA7A850BE4151B2C97649F61527BC_at_CATHY>

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: ; 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?

    -----Original Message-----
    From: []     On Behalf Of Niall Litchfield
    Sent: Monday, November 14, 2011 12:35 PM     To:
    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:
> 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
> solaris
> --


Received on Mon Nov 14 2011 - 14:03:23 CST

Original text of this message