Re: awr scripts

From: ed lewis <eglewis71_at_gmail.com>
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: eglewis71_at_gmail.com ; oracle-l_at_freelists.org 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_at_austin.rr.com> wrote:

    Why does the addm report have to be run before the awr script?

    -----Original Message-----
    From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]     On Behalf Of Niall Litchfield
    Sent: Monday, November 14, 2011 12:35 PM     To: eglewis71_at_gmail.com
    Cc: oracle-l_at_freelists.org
    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_at_gmail.com> 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
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

    --
    http://www.freelists.org/webpage/oracle-l

--
http://www.freelists.org/webpage/oracle-l

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