9.113 V$TEMPSTAT
V$TEMPSTAT
displays information about file read/write statistics.
Column | Datatype | Description |
---|---|---|
|
|
Number of the file |
|
|
Number of physical reads done |
|
|
Number of times DBWR is required to write |
|
|
Number of physical blocks read |
|
|
Number of blocks written to disk, which may be the same as |
|
|
Number of single block reads |
|
|
Time (in hundredths of a second) spent doing reads if the |
|
|
Time (in hundredths of a second) spent doing writes if the |
|
|
Cumulative single block read time (in hundredths of a second) |
|
|
Average time (in hundredths of a second) spent on I/O, if the |
|
|
Time (in hundredths of a second) spent doing the last I/O, if the |
|
|
Minimum time (in hundredths of a second) spent on a single I/O, if the |
|
|
Maximum time (in hundredths of a second) spent doing a single read, if the |
|
|
Maximum time (in hundredths of a second) spent doing a single write, if the |
|
|
The ID of the container to which the data pertains. Possible values include:
|
See Also: