Discussions
Categories
- 196.8K All Categories
- 2.2K Data
- 235 Big Data Appliance
- 1.9K Data Science
- 449.9K Databases
- 221.6K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 549 MySQL Community Space
- 478 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3K ORDS, SODA & JSON in the Database
- 532 SQLcl
- 4K SQL Developer Data Modeler
- 186.9K SQL & PL/SQL
- 21.3K SQL Developer
- 295.5K Development
- 17 Developer Projects
- 138 Programming Languages
- 292.2K Development Tools
- 104 DevOps
- 3.1K QA/Testing
- 645.9K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 154 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.1K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 17 Java Essentials
- 158 Java 8 Questions
- 85.9K Java Programming
- 79 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.2K Java SE
- 13.8K Java Security
- 203 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 402 LiveLabs
- 37 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.6K Other Languages
- 2.3K Chinese
- 171 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 230 Portuguese
Oracle documentation on details of AWR report

Bobby Durrett
Member Posts: 140 Blue Ribbon
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
Anyway, if there is some document that I'm missing on this I would appreciate your help.
- Bobby
Answers
-
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.... -
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 -
Which section you are confused with ??
-
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 -
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 -
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 -
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 -
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.
This discussion has been closed.