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