Oracle10g Automatic Storage Memory Diagnostic Features Automatic Workload Repository Automatic Database Diagnostic Monitor Trend Identification

Redneck

Dress Code

Oracle tuning

Oracle training

Oracle support

Remote Oracle

Oracle Tips by Burleson

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

Trend Identification with the AWR

select
   to_char(begin_interval_time,'day')   snap_time,
   avg(value)                           avg_value
from
   dba_hist_sysstat
natural join
   dba_hist_snapshot

SEE CODE DEPOT FOR FULL SCRIPT
group by
   to_char(begin_interval_time,'day')
order by
   decode(
   to_char(begin_interval_time,'day'),
    'sunday',1,
    'monday',2,
    'tuesday',3,
    'wednesday',4,
    'thursday',5,
    'friday',6,
    'saturday',7
   )
;

The listing below displays the output.

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

For more details and scripts, see my new book " Oracle Tuning: The Definitive Reference", over 900 pages of BC's favorite tuning tips & scripts.

You can buy it direct from the publisher for 30%-off and get instant access to the code depot.

Oracle performance Tuning 10g reference poster

Oracle training & performance tuning books