 |
|
Oracle Tips by Burleson |
Easy Oracle Automation
Chapter 4 -
Automatic Workload Repository and Automatic Database
Diagnostic Monitor
AWR Snapshots
Verify the new values by running the query on
dba_hist_wr_control. For the above example the following
results are obtained:
SNAP_INTERVAL RETENTION
-------------------------
-------------------------
+00000 00:30:00.0 +00030 00:00:00.0
A manual snapshot can also be taken by calling
the PL/SQL procedure dbms_workload_repository.create_snapshot.
This procedure will immediately take a snapshot and record it in
wrm$_snapshot. The metrics at the typical level are collected as
the default. This will help to capture system behavior at specific
points in time outside the monitoring interval. A high interval
value may lead to missing workload spikes.
The following section examines the different
types of statistics and metrics collected and at what frequency they
can be collected.
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
|
|
