Oracle® Database Reference 10g Release 1 (10.1) Part Number B10755-01 |
|
|
View PDF |
V$FILEMETRIC_HISTORY
displays values of file metrics for all intervals in the last one hour.
Column | Datatype | Description |
---|---|---|
BEGIN_TIME |
DATE |
Begin time of the interval |
END_TIME |
DATE |
End time of the interval |
INTSIZE_CSEC |
NUMBER |
Interval size (in hundredths of a second) |
FILE_ID |
NUMBER |
File number |
CREATION_TIME |
NUMBER |
Timestamp of the file creation |
AVERAGE_READ_TIME |
NUMBER |
Average file read time |
AVERAGE_WRITE_TIME |
NUMBER |
Average file write time |
PHYSICAL_READS |
NUMBER |
Number of physical reads |
PHYSICAL_WRITES |
NUMBER |
Number of physical writes |
PHYSICAL_BLOCK_READS |
NUMBER |
Number of physical block reads |
PHYSICAL_BLOCK_WRITES |
NUMBER |
Number of physical block writes |