4.323 DBA_HIST_FILESTATXS
DBA_HIST_FILESTATXS
displays information about file read/write statistics.
This view contains snapshots of V$FILESTAT
.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
|
Unique snapshot ID |
|
|
|
Database ID for the snapshot |
|
|
|
Instance number for the snapshot |
|
|
|
File identification number |
|
|
|
Change number at which the data file was created |
|
|
|
Name of the data file |
|
|
|
Tablespace number |
|
|
|
Name of the tablespace |
|
|
|
Block size of the data file |
|
|
|
Number of physical reads done |
|
|
|
Number of times DBWR is required to write |
|
|
|
Number of single block reads |
|
|
|
Time (in hundredths of a second) spent doing reads if the |
|
|
|
Time (in hundredths of a second) spent doing writes if the |
|
|
|
Cumulative single block read time (in hundredths of a second) |
|
|
|
Number of physical blocks read |
|
|
|
Number of blocks written to disk, which may be the same as |
|
|
|
Shows the number of waits at the file level for contended buffers. This value includes the individual wait events that are included in the buffer busy waits wait event. See Also: "buffer busy waits" |
|
|
|
Time spent waiting for the wait events in the |
|
|
|
Number of physical reads from Database Smart Flash Cache blocks |
|
|
|
The database ID of the PDB for the sampled session |
|
|
|
The ID of the container that
|
See Also: