DBA_HIST_FILESTATXS

DBA_HIST_FILESTATXS displays information about file read/write statistics. This view contains snapshots of V$FILESTAT.

Column	Datatype	Description
`SNAP_ID`	`NUMBER`	Unique snapshot ID
`DBID`	`NUMBER`	Database ID for the snapshot
`INSTANCE_NUMBER`	`NUMBER`	Instance number for the snapshot
`FILE#`	`NUMBER`	File identification number
`CREATION_CHANGE#`	`NUMBER`	Change number at which the datafile was created
`FILENAME`	`VARCHAR2(513)`	Name of the datafile
`TS#`	`NUMBER`	Tablespace number
`TSNAME`	`VARCHAR2(30)`	Name of the tablespace
`BLOCK_SIZE`	`NUMBER`	Block size of the datafile
`PHYRDS`	`NUMBER`	Number of physical reads done
`PHYWRTS`	`NUMBER`	Number of times DBWR is required to write
`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 `TIMED_STATISTICS` is `false`
`WRITETIM`	`NUMBER`	Time (in hundredths of a second) spent doing writes if the `TIMED_STATISTICS` parameter is `true`; `0` if `TIMED_STATISTICS` is `false`
`SINGLEBLKRDTIM`	`NUMBER`	Cumulative single block read time (in hundredths of a second)
`PHYBLKRD`	`NUMBER`	Number of physical blocks read
`PHYBLKWRT`	`NUMBER`	Number of blocks written to disk, which may be the same as `PHYWRTS` if all writes are single blocks
`WAIT_COUNT`	`NUMBER`	Wait Count
`TIME`	`NUMBER`	Wait Time