• From: Jonathan Lewis <jonathan@xxxxxxxxxxxxxxxxxx>
  • To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 4 Sep 2015 08:54:22 +0000

Bearing in mind the enormous overlap between the AWR report and the old
Statspack reports, it's still worth reading the document Oracle published in
2001 about the method. (Some of the details are outdated, of course, and there
are a number of omissions - but I'd still rate it as a good starting point).

Apart from that, you'll find loads of articles and examples on the Internet
about reading Statspack/AWR reports - I've got a catalogue of a number I wrote
(plus a few others) here:

I don't think you're ever likely to find a thorough treatment of AWR online,
there's just too much information that you have to collate for anything but the
most trivial cases (and you'll probably find several examples of those online
very easily), the key thing is to understand the principles - and the pdf from
Oracle hits the high notes on those perfectly well. (This link on my list
covers perhaps the most critical detail that isn't in the original note: )

Jonathan Lewis
From: oracle-l-bounce@xxxxxxxxxxxxx [oracle-l-bounce@xxxxxxxxxxxxx] on behalf
of Michael Calisi [oracle455@xxxxxxxxx]
Sent: 03 September 2015 18:42
To: oracle-l@xxxxxxxxxxxxx
Subject: AWR

Anyone recommend a documentation that can help with reading/understanding
AWR/ASH reports.


  • Follow-Ups:
  • References:
    • AWR
      • From: Michael Calisi

Other related posts: