4.328 DBA_HIST_FILEMETRIC_HISTORY
DBA_HIST_FILEMETRIC_HISTORY
displays the history of file metrics collected in the Workload Repository.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
|
Unique snapshot ID |
|
|
|
Database ID for the snapshot |
|
|
|
Instance number for the snapshot |
|
|
|
File number |
|
|
|
File creation time |
|
|
|
Begin time of the interval |
|
|
|
End time of the interval |
|
|
|
Interval size (in hundredths of a second) |
|
|
|
ID of the group to which the file belongs |
|
|
|
Average file read time |
|
|
|
Average file write time |
|
|
|
Number of physical reads |
|
|
|
Number of physical writes |
|
|
|
Number of physical block reads |
|
|
|
Number of physical block writes |
|
|
|
The database ID of the PDB for the sampled session |
|
|
|
The ID of the container that
|