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).
http://www.oracle.com/technetwork/database/focus-areas/performance/statspack-opm4-134117.pdf
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:
https://jonathanlewis.wordpress.com/statspack-examples/
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:
https://jonathanlewis.wordpress.com/2008/02/18/analysing-statspack/ )
Regards
Jonathan Lewis
http://jonathanlewis.wordpress.com
@jloracle
________________________________
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.
Thanks
