Oracle documentation on details of AWR report

Bobby Durrett

A coworker of mine asked if there was any documentation from Oracle that listed all of the parts of the AWR report and what each meant. I was taken back because I don't think there is. There are third party books that talk about AWR reports and their predecessor Statspack reports. Oracle has some notes on their support site about reading an AWR or Statspack report. All I found in the official documentation was some basic information about how to run an AWR report and an overview of what it was. It would be nice to have some sort of documentation that lists out each section and explains the units and purpose.

Anyway, if there is some document that I'm missing on this I would appreciate your help.

- Bobby

Aman....

No, there is not anything that actually comes closer to what your co-worker is looking for. The documentation explains the meaning of the wait events and the statistics but doesn't really go ahead in a part by part explanation of the section AFAIK.

Aman....

mseberg

Bobby;

Here's what I have :

http://www.oracle.com/technetwork/database/focus-areas/performance/tips-perf-awr-sql-report-129542.pdf

http://docs.oracle.com/cd/B19306_01/server.102/b14211/autostat.htm

Best Regards

mseberg

Edited by: mseberg on Jun 4, 2012 7:44 PM

Karan

Which section you are confused with ??

Bobby Durrett

Thanks for the feedback. My understanding is that the AWR report comes from the DBA_HIST views which are snapshots of the V$ views. So, one could study the views and probably figure out which of them feed the various sections of the AWR report. Still, it would be nice if there was at least a simple list somewhere of each section of the AWR report and the name of the associated DBA_HIST view.

If someone has done this that would be great to know.

- Bobby

Unknown

Jonathan Lewis has a series on statspack. AWR basically is a superset of statspack.
The URL has been posted many, many times here, but the search function is a disaster and no one uses it anyway, which is why the questions which have already been answered many times keep coming in.

-----------
Sybrand Bakker
Senior Oracle DBA

askraks

I appreciate your question.

I read this more than 100 times( 228913.1) when i with Oracle Corporation.
I would suggest please follow this apporach

Architecture
1) What is locks?
2) What is latch and mutex? diffrent latch and mutex on memory pools?
3) wait events
4) Systemwide Tuning using STATSPACK Reports [ID 228913.1] <<<<< read this atleast for 10 times.
5) then start work on sql tuning

Hope this helps you.


Kind Regards,
Rakesh

Bobby Durrett

I think the Jonathan Lewis link is http://jonathanlewis.wordpress.com/statspack-examples/ That seems like a helpful collection of information.

Also, I was looking at Oracle note 1359094.1 - FAQ: How to Use AWR reports to Diagnose Database Performance Issues. This note refers to the Statspack note 228913.1 that was mentioned as well as others that I'm sure are helpful.

I think all these sources are good. Years ago I learned about Statspack from Don Burleson's Oracle 9i Statpack book which was great because it was not only about Statspack but talked about augmenting statspack tables with operating system information. This was similar to Craig Shallahamer's OSM scripts that snapshot the V$ tables and also save OS - VMSTAT, etc.

But, I was thinking that AWR reports might have detailed section by section documentation that statspack didn't have because AWR reports are part of an extra cost feature, but that does not appear to be the case.

Thanks again for the feedback.

- Bobby

Bobby Durrett

Bottom line is that there isn't detailed documentation from Oracle on the contents of an AWR report. But, there is a lot of helpful information from Oracle support and other third parties on reading an AWR or Statspack report and using them to diagnose performance problems.