Automatic Workload Repository Automatic Database Diagnostic Monitor Exception Reporting dba

We are top for USA Oracle Training Clients

Oracle Tips by Burleson

Easy Oracle Automation
Chapter 4 - Automatic Workload Repository and Automatic Database Diagnostic Monitor

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.

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.

http://www.rampant-books.com/book_2004_2_10g_auto.htm

Download your Oracle scripts now:

www.oracle-script.com

The definitive Oracle Script collection for every Oracle professional DBA