V$FILEMETRIC_HISTORY
displays values of file metrics for all intervals in the last one hour.
Column | Datatype | Description |
---|---|---|
|
|
Begin time of the interval |
|
|
End time of the interval |
|
|
Interval size (in hundredths of a second) |
|
|
File number |
|
|
Timestamp of the file creation |
|
|
Average file read time (in hundredths of a second) |
|
|
Average file write time (in hundredths of a second) |
|
|
Number of physical reads |
|
|
Number of physical writes |
|
|
Number of physical block reads |
|
|
Number of physical block writes |
|
|
The ID of the container to which the data pertains. Possible values include:
|