DBA_HIST_FILESTATXS displays information about file read/write statistics. This view contains snapshots of V$FILESTAT.
| Column | Datatype | NULL | 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 |