 |
|
Oracle Tips by Burleson |
Easy Oracle Automation
Chapter 4 -
Automatic Workload Repository and Automatic Database
Diagnostic Monitor
Trend Identification with the AWR
The report_sysstat_day.sql
will
accept any of the values from dba_hist_sysstat and will plot the average
values for physical reads by hour-of-the-day.
report_sysstat_day.sql
--
*************************************************
-- Copyright © 2004 by
Rampant TechPress
-- This script is free
for non-commercial purposes
-- with no warranties.
Use at your own risk.
--
-- To license this
script for a commercial purpose,
--
contact info@rampant.cc
--
*************************************************
prompt This will query the dba_hist_sysstat view to
display
prompt average values for physical reads by
day-of-the-week
prompt
set pages 999
accept stat_name char prompt 'Enter Statistic Name: ';
col snap_time format a19
col avg_value format 999,999,999
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.
 |
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. |
|
