Re: Oracle 10g AWR Report - Analysis/Interpretation

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Sun, 19 Oct 2008 09:49:06 +0100
Message-ID: <pLGdnfZzsOfjaWfVnZ2dnUVZ8q7inZ2d@bt.com>

"Mark D Powell" <Mark.Powell_at_eds.com> wrote in message news:a536269f-3f10-4f2b-ad6c-7dba1d85bcb9_at_v56g2000hsf.googlegroups.com...
> On 16 okt, 20:46, raja <dextersu..._at_gmail.com> wrote:
>
> > I am using oracle 10g, i want to know how to interpret the AWR Report.
> > I searched in google, but cant find any documents on it.
> > Could any one please help me on it, any documents/URLs regarding the
> > interpretation of AWR Report would be helpful to me.
>

> You can also read articles on Statspack since the AWR reports on most
> of the Statspack information.

As Mark says, there's a lot of overlap between Statspack and AWR, so you might want to read some of the examples of interpreting Statspack that I've published on my blog. The following link is a starting point - and
includes references to a couple of other authors. (The item from Connie Green is particularly useful).

http://jonathanlewis.wordpress.com/statspack-examples/

Regards
Jonathan Lewis
http://jonathanlewis.wordpress.com
http://www.jlcomp.demon.co.uk

"The greatest enemy of knowledge is not ignorance, it is the illusion of knowledge." Stephen Hawking. Received on Sun Oct 19 2008 - 03:49:06 CDT

Original text of this message