`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 Database Smart 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` |