V$FILESTAT

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

Fields

The most relevant view fields are as follows:

• FILE#: The file identification number

• PHYRDS: The number of physical reads done

• PHYWRTS: The number of physical writes done

• 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$DATAFILE section in this appendix