V$TEMPSTAT

This view displays statistics about I/O operations on temporary files.

Fields

The most relevant view fields are as follows:

• FILE#: The file identification number

• PHYRDS: The number of physical reads performed

• PHYWRTS: The number of physical writes performed

• READTIM: The time spent doing reads in hundredths of a second

• WRITETIM: The time spent doing writes in hundredths of a second

See also

• The V$TEMPFILE section in this appendix