4.385 DBA_HIST_IOSTAT_FILETYPE
DBA_HIST_IOSTAT_FILETYPE
displays historical I/O statistics by file type.
This view contains snapshots of V$IOSTAT_FILE
.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
|
Unique snapshot ID |
|
|
|
Database ID for the snapshot |
|
|
|
Instance number for the snapshot |
|
|
|
Type of file (for example, log file, data file, and so on) |
|
|
|
Name of the file, in the case of a data file or temp file. For all other files, a corresponding string to be displayed (for example, |
|
|
|
Number of single block megabytes read |
|
|
|
Number of single block megabytes written |
|
|
|
Number of multiblock megabytes read |
|
|
|
Number of multiblock megabytes written |
|
|
|
Number of single block read requests |
|
|
|
Number of single block write requests |
|
|
|
Number of synchronous single block read requests |
|
|
|
Number of multiblock read requests |
|
|
|
Number of multiblock write requests |
|
|
|
Total service time (in milliseconds) for single block read requests |
|
|
|
Total service time (in milliseconds) for single block write requests |
|
|
|
Latency for single block synchronous reads (in milliseconds) |
|
|
|
Total service time (in milliseconds) for multiblock read requests |
|
|
|
Total service time (in milliseconds) for multiblock write requests |
|
|
|
Number of read retries on error |
|
|
|
The database ID of the PDB for the sampled session |
|
|
|
The ID of the container that
|
See Also: