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 the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
