Creating Custom AWR Reports

select
   begin_interval_time,
   filename,
   phyrds
from
   dba_hist_filestatxs
natural join
   dba_hist_snapshot
;

Below is the result.  Note that the snapshots are collected every half-hour.  Using this script and adding where clause criteria could create a unique time-series exception report.

SQL> @physical_reads

BEGIN_INTERVAL_TIME       FILENAME                                  PHYRDS                
------------------------- ----------------------------------------  ------
24-FEB-04 11.00.32.000 PM E:\ORACLE\ORA92\FSDEV10G\SYSTEM01.DBF     164,700
                          E:\ORACLE\ORA92\FSDEV10G\UNDOTBS01.DBF    26,082
                          E:\ORACLE\ORA92\FSDEV10G\SYSAUX01.DBF     472,008 
                          E:\ORACLE\ORA92\FSDEV10G\USERS01.DBF      1,794   
                          E:\ORACLE\ORA92\FSDEV10G\T_FS_LSQ.ORA     2,123