Correlation Analysis Reports with AWR and
ASH Views
Table 4.15 - Selected columns from the
dba_hist_active_sess_history view
The
listing below displays the wait_time_detail.sql
script that compares
the wait event values from dba_hist_waitstat and
dba_hist_active_sess_history. This allows
for identification
of
the exact objects
that are experiencing wait events.
wait_time_detail.sql
--
*************************************************
--
Copyright © 2004 by Rampant TechPress
-- This
script is free for non-commercial purposes
-- with
no warranties. Use at your own risk.
--
-- To
license this script for a commercial purpose,
-- contact info@rampant.cc
--
*************************************************
prompt This will compare values from
dba_hist_waitstat with
prompt detail information from
dba_hist_active_sess_historyError! Bookmark
not defined..
prompt
set pages 999
set lines 80
break on snap_time skip 2
col snap_time heading 'Snap|Time'
format a20
