Skip Headers
Oracle® Database Reference
10g Release 2 (10.2)

Part Number B14237-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page
Previous
Go to next page
Next
View PDF

V$FILEMETRIC

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