Correlation Analysis Reports with AWR and ASH Views

and
   obj.object_id = ash.current_obj#
and
   wait_count > 50
order by
   to_char(begin_interval_time,'yyyy-mm-dd hh24:mi'),
   file_name
;

Note that this script is enabled to join into the dba_data_files view to get the file names associated with the wait event.  This is a very powerful script that can be used to quickly drill-in to find the cause of specific waits.  The sample output is listed below.

SQL> @wait_time_detail
 
Copyright 2004 by Donald K. Burleson -used with permission

This will compare values from dba_hist_waitstat with
detail information from dba_hist_active_sess_hist.