Anatomy of an Oracle Automatic Workload Repository (AWR) Report

This chapter contains sections titled:

• Importance of Performance Statistics

• AWR Report Header

• Report Summary

• Main Report

• Wait Events Statistics

• SQL Statistics

• Instance Activity Statistics

• IO Stats

• Buffer Pool Statistics

• Advisory Statistics

• Wait Statistics

• Undo Statistics

• Latch Statistics

• Segment Statistics

• Dictionary Cache Stats

• Library Cache Activity

• Memory Statistics

• Streams Statistics

• Resource Limit Stats

• init.ora Parameters

• Summary

• Recommended Reading

• Exercises

]]>