V$FILEMETRIC displays values of file metrics for the most recent 10-minute interval. A history of the last one hour will be kept in the system.
| 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 |