DBA_HIST_TEMPSTATXS

DBA_HIST_TEMPSTATXS displays information about temporary file read/write statistics. This view contains snapshots of V$TEMPSTAT.

Column	Datatype	NULL	Description
`SNAP_ID`	`NUMBER`	`NOT NULL`	Unique snapshot ID
`DBID`	`NUMBER`	`NOT NULL`	Database ID for the snapshot
`INSTANCE_NUMBER`	`NUMBER`	`NOT NULL`	Instance number for the snapshot
`FILE#`	`NUMBER`	`NOT NULL`	File identification number
`CREATION_CHANGE#`	`NUMBER`	`NOT NULL`	Change number at which the tempfile was created
`FILENAME`	`VARCHAR2(513)`	`NOT NULL`	Name of the tempfile
`TS#`	`NUMBER`	`NOT NULL`	Tablespace number
`TSNAME`	`VARCHAR2(30)`	`NOT NULL`	Name of the tablespace
`BLOCK_SIZE`	`NUMBER`		Block size of the tempfile
`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 `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)
`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