Exception reporting with dba_hist_filestatxs

Below is the sample output.  This is a very useful report because it shows the high-write datafiles and the times when they are hot.

SQL> @hot_write_files

This will identify any single file whose write I/O
is more than 25% of the total write I/O of the database.

SNAP_TIME            FILENAME                              PHYWRTS
----------------- ---------------------------------------- ------
                                                                                                                             
2004-02-20 23:30  E:\ORACLE\ORA92\FSDEV10G\SYSAUX01.DBF     85,540
2004-02-21 01:00  E:\ORACLE\ORA92\FSDEV10G\SYSAUX01.DBF     88,843   
2004-02-21 08:31  E:\ORACLE\ORA92\FSDEV10G\SYSAUX01.DBF     89,463
2004-02-22 02:00  E:\ORACLE\ORA92\FSDEV10G\SYSAUX01.DBF     90,168
2004-02-22 16:30  E:\ORACLE\ORA92\FSDEV10G\SYSAUX01.DBF     143,974
                  E:\ORACLE\ORA92\FSDEV10G\UNDOTBS01.DBF    88,973