RE: AWR
Date: Fri, 4 Sep 2015 08:54:22 +0000
Message-ID: <CE70217733273F49A8A162EE074F64D9282A2600_at_EXMBX01.thus.corp>
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
_at_jloracle
From: oracle-l-bounce_at_freelists.org [oracle-l-bounce_at_freelists.org] on behalf of Michael Calisi [oracle455_at_gmail.com] Sent: 03 September 2015 18:42
To: oracle-l_at_freelists.org
Subject: AWR
Anyone recommend a documentation that can help with reading/understanding AWR/ASH reports.
Thanks
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Sep 04 2015 - 10:54:22 CEST