DBA AWR Wait Event Summary

Description

Categories
Enginatics
Repository
GitHub
Summary of wait times by wait event and event class for a specified snapshot time interval.
Use the Session Type parameter to restrict either to foreground, background or all server processes.

To see data in this report based on dba_hist_system_event, set the following:
alter session set container=PDB1;
alter system set awr_pdb_autoflush_enabled=true;

https://www.enginatics.com/blog/updated-dba-awr-blitz-reports-now-work-with-plugglable-databases/

SQL 46 lines

Parameters 9

ParameterTypeList of values SQL
Date FromLOV
dhs.end_interval_time>=xxen_util.server_time(fnd_date.displaydt_to_date(:date_from))-1/1440
Date ToLOV
dhs.begin_interval_time<=xxen_util.server_time(fnd_date.displaydt_to_date(:date_to))
Session TypeLOV
Level of DetailLOV
dhse.event_name,
Request Id (Time Restriction)Number
(dhs.begin_interval_time<=(select fcr.actual_completion_date from fnd_concurrent_requests fcr where fcr.request_id=:request_id) and dhs.end_interval_time>=(select fcr.actual_start_date from fnd_concurrent_requests fcr where fcr.request_id=:request_id))
Time RestrictionLOV
to_number(to_char(dhs.begin_interval_time,'HH24')) between 6 and 18 and to_char(dhs.begin_interval_time,'DAY') not in ('SATURDAY','SUNDAY')
Include Idle EventsLOV Oracle
dhse.wait_class<>'Idle'
Diagnostic Pack enabledLOV
1=1
Container DataLOV
dhs.dbid=(select vd.dbid from v$database vd)