Databases Reference
In-Depth Information
V$TEMPSTAT
This view displays statistics about I/O operations on temporary files.
Fields
The most relevant view fields are as follows:
F
FILE#
: The file identification number
F
PHYRDS
: The number of physical reads performed
F
PHYWRTS
: The number of physical writes performed
F
READTIM
: The time spent doing reads in hundredths of a second
F
WRITETIM
: The time spent doing writes in hundredths of a second
See also
F
The
V$TEMPFILE
section in this appendix
V$WAITSTAT
This view displays block contention statistics.
Fields
The most relevant view fields are as follows:
F
CLASS
: The class of the block
F
COUNT
: The number of waits for this
CLASS
of block
F
TIME
: The sum of all wait times for this
CLASS
of block
See also
F
The
V$SESSION
and
V$SESSION_EVENT
sections in this appendix