| |
 |
|
Oracle Tips by Burleson |
Easy Oracle Automation
Chapter 4 -
Automatic Workload Repository and Automatic Database
Diagnostic Monitor
Architecture of AWR
Automatic Workload Repository (AWR) provides a
new infrastructure for collecting baseline statistics. Here is a
partial list of the many statistics AWR in Oracle Database 10g
collects:
-
Time model statistics based on time
spent by the activities.
-
Object statistics that represent
the access and usage statistics of database segments.
-
Some session and system statistics
retained in v$sesstat and v$sysstat.
-
Some optimizer statistics for
self-learning and tuning, ADDM, and Active Session History (ASH).
The following statistics are the most important
ones used by AWR:
-
OS Statistics - CPU and Memory
using v$osstat.
-
Wait Classes - CPU, application,
commit, concurrency, scheduler, I/O, admin, configuration, commit,
cluster, and network using v$event_name.
-
Time Model - Connection management,
PL/SQL compilation, parse, SQL execution, and PL/SQL execution using
v$sys_time_model.
-
SQL Statistics - SQL statistics
(PL/SQL Java time, wait-class time), bind variables, efficient top
SQL based on CPU, elapsed and parse statistics.
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
|
|
