Automatic Workload Repository (AWR) Reports - Start Point (文档 ID 1363422.1)

In this Document

 Purpose Scope Automatic Workload Repository (AWR) Overview Details Collecting AWR reports AWR Interpretation AWR setup and Troubleshooting setup Issues AWR Setup AWR Troubleshooting AWR Storage Management Common Issues If awrinfo.sql hangs, use following script: References

---

APPLIES TO:

Oracle Database - Enterprise Edition - Version 10.1.0.2 and later
Information in this document applies to any platform.

PURPOSE

This document outlines the primary information sources regarding all aspects of AWR reports.

SCOPE

Automatic Workload Repository (AWR) Overview

Automatic Workload Repository (AWR) is a licensed feature that allows information to be recorded on a database for multiple purposes including detection and elimination of performance issues.
For a general overview of Performance Advisors and Manageability Features, see:

Document 276103.1 PERFORMANCE TUNING USING 10g ADVISORS AND MANAGEABILITY FEATURES

Assuming you have the appropriate licenses for AWR, you may gather and examine Automatic Workload Repository (AWR) reports for the system.

Document 1490798.1 AWR Reporting - Licensing Requirements Clarification

Without the appropriate licenses, Statspack provides a legacy solution:

Document 94224.1 FAQ- Statspack Complete Reference

DETAILS

Collecting AWR reports

Document 748642.1 How to Generate an AWR Report and Create Baselines

AWR Interpretation

Document 1359094.1 FAQ: How to Use AWR reports to Diagnose Database Performance Issues

Document 786554.1 How to Read PGA Memory Advisory Section in AWR and Statspack Reports
Document 754639.1 How to Read Buffer Cache Advisory Section in AWR and Statspack Reports.

Document 762526.1 How to Interpret the OS stats section of an AWR report
Document 1466035.1 How to Interpret the "SQL ordered by Physical Reads (UnOptimized)" Section in AWR Reports (11.2 onwards)

AWR setup and Troubleshooting setup Issues

This section covers the setup of AWR and troubleshooting of problems related to that:

AWR Setup

Document 782974.1 How to Recreate The AWR ( AUTOMATIC WORKLOAD ) Repository ?

AWR Troubleshooting

Document 1301503.1 Troubleshooting: AWR Snapshot Collection issues

Document 296765.1 Solutions for possible AWR Library Cache Latch Contention Issues in Oracle 10g
Document 560204.1 MMON TRACE SHOWS KEWRAFC: FLUSH SLAVE FAILED, AWR ENQUEUE TIMEOUT

AWR Storage Management

Document 1399365.1 Troubleshooting Issues with SYSAUX

Document 287679.1 Space Management In Sysaux Tablespace with AWR in Use
Document 329984.1 Usage and Storage Management of SYSAUX tablespace occupants SM/AWR, SM/ADVISOR, SM/OPTSTAT and SM/OTHER

Common Issues

Document 459887.1 ORA-13516 AWR Operation failed: SWRF Schema not initialized ORA-06512 SYS.DBMS_WORKLOAD_REPOSITORY

If awrinfo.sql hangs, use following script:

Document 733655.1 AWR diagnostic collection script

REFERENCES

NOTE:329984.1 - Usage and Storage Management of SYSAUX tablespace occupants SM/AWR, SM/ADVISOR, SM/OPTSTAT and SM/OTHER
NOTE:459887.1 - ORA-13516 AWR Operation failed: SWRF Schema not initialized ORA-06512 SYS.DBMS_WORKLOAD_REPOSITORY
NOTE:560204.1 - MMON TRACE SHOWS KEWRAFC: FLUSH SLAVE FAILED, AWR ENQUEUE TIMEOUT
NOTE:733655.1 - AWR diagnostic collection script
NOTE:748642.1 - How to Generate an AWR Report and Create Baselines
NOTE:754639.1 - How to Read Buffer Cache Advisory Section in AWR and Statspack Reports.
NOTE:782974.1 - How to Recreate The AWR ( AUTOMATIC WORKLOAD ) Repository ?
NOTE:786554.1 - How to Read PGA Memory Advisory Section in AWR and Statspack Reports
NOTE:94224.1 - FAQ- Statspack Complete Reference
NOTE:1490798.1 - AWR Reporting - Licensing Requirements Clarification
NOTE:1301503.1 - Troubleshooting: AWR Snapshot Collection issues
NOTE:1359094.1 - FAQ: How to Use AWR reports to Diagnose Database Performance Issues
NOTE:276103.1 - Performance Tuning Using Advisors and Manageability Features: AWR, ASH, ADDM and Sql Tuning Advisor
NOTE:287679.1 - AWR Data Uses Significant Space in the SYSAUX Tablespace
NOTE:296765.1 - Solutions for possible AWR Library Cache Latch Contention Issues in Oracle 10g
NOTE:1399365.1 - Troubleshooting Issues with SYSAUX

  

相关内容

   

 

产品

   

• Oracle Database Products > Oracle Database > Oracle Database > Oracle Database - Enterprise Edition > RDBMS > Database Level Performance Issues (not SQL Tuning)

 

关键字

   

AUTOMATIC WORKLOAD REPOSITORY;AWR;INFORMATION CENTER;REPOSITORY

 

错误

   

ORA-13516;ORA-6512