 |
|
Oracle Tips by Burleson |
Easy Oracle Automation
Chapter 4 -
Automatic Workload Repository and Automatic Database
Diagnostic Monitor
Exception reporting with
dba_hist_filestatxs
|
COLUMN |
DESCRIPTION |
|
SNAP_ID |
Unique snapshot ID |
|
FILENAME |
Name of the datafile |
|
PHYRDS |
Number of physical reads done |
|
PHYWRTS |
Number of times DBWR is required to
write |
|
SINGLEBLKRDS |
Number of single block reads |
|
READTIM |
Time (in hundredths of a second)
spent doing reads if the timed_statistics
parameter is true; 0 if timed_statistics is false |
|
WRITETIM |
Time (in hundredths of a second)
spent doing writes if the timed_statistics parameter
is true; 0 if timed_statistics
is false |
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
|
|
