DBA AWR Wait Class by Time

Description

Categories
Enginatics
Repository
GitHub
Non idle session wait times by wait class over time.
Each row shows the system-wide wait time per wait class of one AWR snapshot interval to identify unusual wait events that occured at specific times.
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 101 lines

Parameters 5

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
Diagnostic Pack enabledLOV
1=1
Container DataLOV
dhs.dbid=(select vd.dbid from v$database vd)