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 ...