8.1. Using the Automatic Workload Repository (AWR)

The Automatic Workload Repository (AWR) is the cornerstone of the CMI. AWR provides services to collect, process, maintain, and access database performance statistics and metrics for the database.

This section discusses the two elements that make up AWR:

  • The statistics collection facility, which is charged with the collection of dynamic performance statistics

  • The workload repository, where the statistics are stored for persistence

We'll also describe the Active Session History (ASH) buffer and how the Manageability Monitor (MMON) process captures statistics from ASH for inclusion in the workload repository.

Next, you'll learn how to use AWR to manage snapshots and baselines. Snapshots represent ...

Get OCP: Oracle 10g Administration II Study Guide: Exam 1Z0-043 now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.