Oracle Consulting Oracle Training Oracle Support Development
Oracle Books
SQL Server Books
IT Books
Job Interview Books
Rampant Horse Books
911 Series
Pedagogue Books

Oracle Software
Write for Rampant
Publish with Rampant
Rampant News
Rampant Authors
Rampant Staff
Oracle News
Oracle Forum
Oracle Tips
Articles by our Authors
Press Releases
SQL Server Books

Oracle 11g Books

Oracle tuning

Oracle training

Oracle support

Remote Oracle


Privacy Policy


  Oracle Tips by Burleson

Easy Oracle Automation
Chapter 4 -
Automatic Workload Repository and Automatic Database Diagnostic Monitor

What is AWR?

Automatic Workload Repository (AWR) forms the central component of the new Oracle Database 10g manageability infrastructure. It provides services to the database to access, collect, process, and maintain performance statistics on various functionalities within the database. It is a built-in repository in every database.

During regular intervals, Oracle Database 10g takes snapshots of all vital statistics and workload data, and then stores them in the repository. This data is later used for analysis and as statistics for problem detection and self-tuning. By default the interval is 60 minutes and the data is stored for a period of seven days, after which it then gets purged. The interval and retention period can be altered.

Please note that in Oracle Database Concepts 10g Release 1 (10.1) documentation, Part Number B10743-0114 under Manageability (Chapter 14), it is incorrectly stated that the snapshot interval is 30 minutes. The incorrect statement reads: “By default, the snapshots are made every 30 minutes, but you can change this frequency.”

This captured data can be used for system level and user level analysis. This data is optimized to minimize overhead. In a nutshell, AWR is the basis for all self-management functionalities of the database. It helps with the historical perspective on database usage enabling accurate decisions to be made quickly.

The AWR infrastructure consists of two major components.  They are as follows:

The above text is an excerpt from:

Easy Oracle Automation
Oracle10g Automatic Storage, Memory and Diagnostic Features

ISBN 0-9745993-6-0

by Dr. Arun Kumar R.

Download your Oracle scripts now:

The definitive Oracle Script collection for every Oracle professional DBA

Linux Oracle commands syntax poster

ION Oracle tuning software

Oracle data dictionary reference poster

Oracle Forum

BC Oracle consulting support training

BC remote Oracle DBA   



 Copyright © 1996 -2017 by Burleson. All rights reserved.

Oracle® is the registered trademark of Oracle Corporation. SQL Server® is the registered trademark of Microsoft Corporation. 
Many of the designations used by computer vendors to distinguish their products are claimed as Trademarks