Correlation Analysis Reports with AWR and ASH Views

col file_name     heading 'File|Name'   format a40
col object_type   heading 'Object|Type' format a10
col object_name   heading 'Object|Name' format a20
col wait_count    heading 'Wait|Count'  format 999,999
col time          heading 'Time'        format 999,999

select
   to_char(begin_interval_time,'yyyy-mm-dd hh24:mi') snap_time,
--   file_name,
   object_type,
   object_name,
   wait_count,
   time
from
   dba_hist_waitstat            wait,
   dba_hist_snapshot            snap,
   dba_hist_active_sess_history ash,
   dba_data_files               df,
   dba_objects                  obj
SEE CODE DEPOT FOR FULL SCRIPT