DBA AWR Wait Event Summary (active session history)

➜ Back to Library
Description
Categories: Enginatics
Repository: Github
Wait event and CPU usage summary from the AWR active session history.
select
100*dhash.seconds/xxen_util.zero_to_null(sum(dhash.seconds) over (partition by &dhash_instance_number 1)) percentage,
dhash.seconds/dhash.total_seconds active_sessions,
xxen_util.time(dhash.seconds) time,
&dhash_instance_number
dhash.seconds,
dhash.wait_class,
&dhash_event
xxen_util.time(dhash.total_seconds) time_window
from
(
select distinct
&dhash_instance_number
count(*) over (partition by &dhash_instance_number dhash.wait_class,&dhash_event 1)*10 seconds,
nvl(dhash.wait_class,'ON CPU') wait_class,
&dhash_event
(max(cast(dhash.sample_time as date)) over (partition by &dhash_instance_number 1)-min(cast(dhash.sample_time as date)) over (partition by &dhash_instance_number 1))*86400 total_seconds
from
dba_hist_active_sess_history dhash
where
1=1
) dhash
order by
&dhash_instance_number
seconds desc
Parameter NameSQL textValidation
From Time
dhash.sample_time>=:from_time
DateTime
To Time
dhash.sample_time<=:to_time
DateTime
By Instance
dhash.instance_number,
LOV
By Event
dhash.event,
LOV
Session Type
dhash.session_type=upper(:session_type)
LOV
Diagnostic Pack enabled
1=1
LOV
Container Data
dhash.dbid=(select vd.dbid from v$database vd)
LOV
Download
Related Blitz Reports
DBA AWR Settings DBA AWR Blocking Session Summary DBA AWR Active Session History DBA AWR CPU Load (active session history) DBA AWR System Metrics Summary DBA SGA Active Session History DBA AWR CPU vs Wait Time Summary DBA SGA+PGA Memory Configuration DBA AWR Wait Event Summary
Blitz Report™