My Oracle Support Banner

How to Use AWR Reports to Diagnose Database Performance Issues (Doc ID 1359094.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Financials Accounting Hub - Version 12.1.3 and later
Oracle Database - Enterprise Edition - Version 10.2.0.1 and later
Oracle Net Services - Version 10.2.0.5 to 10.2.0.5 [Release 10.2]
Information in this document applies to any platform.

Goal

This article aims to provide guidance on how to interpret AWR information specifically for Database Performance issues.

Please remember in order to produce reports, access AWR views, or use the diagnostic information from any part of the Automatic Workload Repository, the Diagnostic Pack License is required. This includes the production of AWR reports, ADDM reports and ASH reports even if these are requested by product support or other agencies.

NOTE: Oracle Diagnostics Pack (and Oracle Tuning Pack) is available with Enterprise Edition ONLY. For further details of pack licensing see:

Oracle® Database Licensing Information
12c Release 1 (12.1)
Part number E17614-08
Chapter 1 1 Oracle Database Editions
Feature Availability by Edition
http://docs.oracle.com/database/121/DBLIC/options.htm#DBLIC139

 

Best Practices

Pro-Active Problem Avoidance and Diagnostic Collection

Although some problems may be unforeseen, in many cases problems may be avoidable if signs are detected early enough. Additionally, if an issue does occur, it is no use collecting information about that issue after the event. AWR reports are one of the support recommend methods for collecting such diagnostics. For information on suggested uses, other proactive preparations and diagnostics, see:

<Document 1482811.1> Best Practices: Proactively Avoiding Database and Query Performance Issues
<Document 1477599.1> Best Practices Around Data Collection For Performance Issues

Ask Questions, Get Help, And Share Your Experiences With This Article

Would you like to explore this topic further with other Oracle Customers, Oracle Employees, and Industry Experts?

Click here to join the discussion where you can ask questions, get help from others, and share your experiences with this specific article.
Discover discussions about other articles and helpful subjects by clicking here to access the main My Oracle Support Community page for Database Tuning.

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
 Best Practices
 Pro-Active Problem Avoidance and Diagnostic Collection
 Ask Questions, Get Help, And Share Your Experiences With This Article
Solution
 AWR Webcast
 Interpretation
 Top 5 Timed Events
 SQL Statistics
 Analysis:
 Other SQL Statistic Sections
 Load Profile
 Instance Efficiency
 Latch Activity
 Notable timed and wait events:
 CPU time events
 Analysis:
 Actions:
 Other Potential CPU related Issues:
 Check to see if other waits follow the high CPU timed event.
 High External CPU usage
 Troubleshooting CPU usage
 'Log file sync' waits
 Buffer busy waits
 Waits for 'Cursor: mutex/pin'
 Troubleshooting Other Issues
 Use of ADDM Reports alongside AWR
 Other AWR reference Articles
 Statspack
 Discuss Diagnosis of Performance Issues Using AWR Reports
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.