Exception reporting with
The dba_hist_filestatxs view
contains important file-level information about Oracle I/O
activities. Because most Oracle databases perform a high amount
of reading and writing from disk, the dba_hist_filestatxs
view can be very useful for identifying high-use data files.
For Oracle Database 10g customer
using the SAME (Stripe and Mirror Everywhere) approach
this view is indispensable for locating and isolating hot data
files. Many Oracle shops will isolate hot data files onto
high-speed solid-state disk (SSD), or relocate the hot files to
another physical disk spindle.
A describe of dba_hist_filestatxs is
shown below. The important information relates to physical
reads and writes, the actual time spent performing reads and
writes, and the wait count associated with each data file for