Oracle® Database Reference 11g Release 2 (11.2) Part Number E10820-02 |
|
|
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 |