 |
|
Oracle Tips by Burleson |
Easy Oracle Automation
Chapter 4 -
Automatic Workload Repository and Automatic Database
Diagnostic Monitor
How Does AWR Compare Against STATSPACK?
natural join
dba_hist_snapshot ;
The output of the script is shown below. It
shows a list total of physical reads by datafile. Note that the
snapshots
are collected every half-hour. Starting with this script,
where clause criteria could easily be added to create a unique
time-series exception report.
SQL> @reads
BEGIN_INTERVAL_TIME
FILENAME PHYRDS
-------------------------
--------------------------------------
----------
24-FEB-04 11.00.32.000 PM
E:\ORACLE\ORA92\FSDEV10G\SYSTEM01.DBF 164,700
E:\ORACLE\ORA92\FSDEV10G\UNDOTBS01.DBF
26,082
E:\ORACLE\ORA92\FSDEV10G\SYSAUX01.DBF
472,008
E:\ORACLE\ORA92\FSDEV10G\USERS01.DBF
1,794
E:\ORACLE\ORA92\FSDEV10G\T_FS_LSQ.OR
2,123
24-FEB-04 11.30.18.296 PM
E:\ORACLE\ORA92\FSDEV10G\SYSTEM01.DBF
167,809
E:\ORACLE\ORA92\FSDEV10G\UNDOTBS01.DBF
26,248
E:\ORACLE\ORA92\FSDEV10G\SYSAUX01.DBF
476,616
E:\ORACLE\ORA92\FSDEV10G\USERS01.DBF
1,795
E:\ORACLE\ORA92\FSDEV10G\T_FS_LSQ.ORA
2,244
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.
|
Download your Oracle scripts now:
www.oracle-script.com
The
definitive Oracle Script collection for every Oracle professional DBA
|
|
