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