DBA AWR CPU vs Wait Time Summary

Description

Categories
Enginatics
Repository
GitHub
Summary of database CPU vs. wait times and average active sessions for a specified time frame

To see data in this report based on dba_hist_sys_time_model, 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 50 lines

Parameters 7

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