Exception Reporting with the AWR

--
-- To license this script for a commercial purpose,
-- contact info@rampant.cc
-- *************************************************

prompt
prompt  This will query the dba_hist_sysstat view to display all values
prompt  that exceed the value specified in
prompt  the "where" clause of the query.
prompt
 
set pages 999
 
break on snap_time skip 2

accept stat_name   char   prompt 'Enter Statistic Name:  ';
accept stat_value  number prompt 'Enter Statistics Threshold value:  ';


col snap_time   format a19
col value       format 999,999,999