Exception Reporting with the AWR
This will query the dba_hist_sysstat view
to display all values
that exceed the value specified in
the "where" clause of the query.
Enter Statistic Name: physical writes
Enter Statistics Threshold value: 200000
SNAP_TIME VALUE
------------------- ------------
2004-02-21 08:00 200,395
2004-02-27 08:00 342,231
2004-02-29 08:00 476,386
2004-03-01 08:00 277,282
2004-03-02 08:00 252,396
2004-03-04 09:00 203,407
The listing above indicates a repeating trend, where physical
writes seem to be high at 8:00 AM on certain days. This
powerful script permits quick extraction of exception conditions
from any instance-wide Oracle metric to review over time. A
more powerful exception report will be examined next that
compares system-wide values to individual snapshots.
