V$FILESTAT

V$FILESTAT displays the number of physical reads and writes done and the total number of single-block and multiblock I/Os done at file level. As of Oracle Database 10g Release 2 (10.2), this view also includes reads done by RMAN processes for backup operations.

Column	Datatype	Description
`FILE#`	`NUMBER`	Number of the file
`PHYRDS`	`NUMBER`	Number of physical reads done
`PHYWRTS`	`NUMBER`	Number of times DBWR is required to write
`PHYBLKRD`	`NUMBER`	Number of physical blocks read
`OPTIMIZED_PHYBLKRD`	`NUMBER`	Number of physical reads from flash cache blocks
`PHYBLKWRT`	`NUMBER`	Number of blocks written to disk, which may be the same as `PHYWRTS` if all writes are single blocks
`SINGLEBLKRDS`	`NUMBER`	Number of single block reads
`READTIM`	`NUMBER`	Time (in hundredths of a second) spent doing reads if the `TIMED_STATISTICS` parameter is `true`; `0` if `false`
`WRITETIM`	`NUMBER`	Time (in hundredths of a second) spent doing writes if the `TIMED_STATISTICS` parameter is `true`; `0` if `false`
`SINGLEBLKRDTIM`	`NUMBER`	Cumulative single block read time (in hundredths of a second)
`AVGIOTIM`	`NUMBER`	Average time (in hundredths of a second) spent on I/O, if the `TIMED_STATISTICS` parameter is `true`; `0` if `false`
`LSTIOTIM`	`NUMBER`	Time (in hundredths of a second) spent doing the last I/O, if the `TIMED_STATISTICS` parameter is `true`; `0` if `false`
`MINIOTIM`	`NUMBER`	Minimum time (in hundredths of a second) spent on a single I/O, if the `TIMED_STATISTICS` parameter is `true`; `0` if `false`
`MAXIORTM`	`NUMBER`	Maximum time (in hundredths of a second) spent doing a single read, if the `TIMED_STATISTICS` parameter is `true`; `0` if `false`
`MAXIOWTM`	`NUMBER`	Maximum time (in hundredths of a second) spent doing a single write, if the `TIMED_STATISTICS` parameter is `true`; `0` if `false`