Exception Reporting with the AWR
select
to_char(begin_interval_time,'yyyy-mm-dd
hh24:mi') snap_time,
value
from
dba_hist_sysstat
natural join
dba_hist_snapshot
SEE CODE DEPOT FOR FULL SCRIPT
order by
to_char(begin_interval_time,'yyyy-mm-dd
hh24:mi')
;
When this script is run, it prompts for the
statistic name and threshold value.
SQL> @report_sysatst
Copyright 2004 by Donald K. Burleson -used
with permission