 |
|
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:
www.oracle-script.com
The
definitive Oracle Script collection for every Oracle professional DBA
|
|
