Automatic Workload Repository

The Automatic Workload Repository (AWR) contains significant information that can be helpful when it comes to tuning the database environment. The database takes regular snapshots to get information about the database settings and the workload in the environment, and stores them in the AWR metadata tables (WRM$_) and historical statistics tables (WRH$_).

In Oracle Database 11g, these reports and information are part of the Oracle Diagnostic Pack, which provides automated gathering of the information and ways to pull the information out of the workload and history tables for review and evaluation of performance issues. You can also create baseline templates to be able to compare information. Baselines are especially ...

Get Oracle Database Administration for Microsoft SQL Server DBAs now with the O’Reilly learning platform.

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