• From: Vishal Gupta <vishal@xxxxxxxxxxxxxxx>
  • To: <jonathan@xxxxxxxxxxxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 16 Sep 2015 15:50:16 +0100

Worth reading following on Oracle support site.

AWR Interpretation
A video entitled: "Introduction to Performance Analysis Using AWR and ASH" is
available here providing a comprehensive guided tour using an actual problem.

Document 1628089.1 AWR Report Interpretation Checklist for Diagnosing Database
Performance Issues
Document 1359094.1 How to Use AWR reports to Diagnose Database Performance

Document 786554.1 How to Read PGA Memory Advisory Section in AWR and Statspack
Document 754639.1 How to Read Buffer Cache Advisory Section in AWR and
Statspack Reports.

Document 762526.1 How to Interpret the OS stats section of an AWR report
Document 1466035.1 How to Interpret the "SQL ordered by Physical Reads
(UnOptimized)" Section in AWR Reports (11.2 onwards)

Vishal Gupta

From: <oracle-l-bounce@xxxxxxxxxxxxx> on behalf of Jonathan Lewis
Reply-To: <jonathan@xxxxxxxxxxxxxxxxxx>
Date: Friday, 4 September 2015 09:54
To: "oracle-l@xxxxxxxxxxxxx"
Subject: RE: AWR

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.


  • References:
    • AWR
      • From: Michael Calisi
    • RE: AWR
      • From: Jonathan Lewis

Other related posts: