Exception reporting with dba_hist_filestatxs

select
   to_char(begin_interval_time,'yyyy-mm-dd hh24:mi') snap_time,       
   filename,
   phywrts
from
   dba_hist_filestatxs
natural join
   dba_hist_snapshot
SEE CODE DEPOT FOR FULL SCRIPT
select
   avg(value)               all_physical_writes
from
   dba_hist_sysstat
  natural join
   dba_hist_snapshot
SEE CODE DEPOT FOR FULL SCRIPT
order by
   to_char(begin_interval_time,'yyyy-mm-dd hh24:mi'),
   phywrts desc
;