DBA AWR Wait Event Summary (active session history) – Oracle EBS SQL Report
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.
Overview
Wait event and CPU usage summary from the AWR active session history.
Report Parameters
From Time, To Time, By Instance, By Event, Session Type, Diagnostic Pack enabled, Container Data
Oracle EBS Tables Used
Report Categories
Related 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
Running This SQL Without Blitz Report
Some Oracle EBS SQL reports in this library require functions from the utility package xxen_util. Install it before running the SQL directly against your Oracle EBS database.
Download & Import Options
| Resource | Link |
|---|---|
| Excel Example Output | DBA AWR Wait Event Summary (active session history) 23-Sep-2025 104849.xlsx |
| Blitz Report™ XML Import | DBA_AWR_Wait_Event_Summary_active_session_history.xml |
| Full SQL on Enginatics | www.enginatics.com/reports/dba-awr-wait-event-summary-active-session-history/ |
Executive Summary
The DBA AWR Wait Event Summary (active session history) report provides a highly granular view of database waits. Unlike the standard “System Wait Event” report which aggregates data globally, this report uses Active Session History (ASH) data. This allows you to filter waits by specific dimensions like User, Module, Action, or SQL ID. It answers “Who?” and “What?” rather than just “How much?”.
Business Challenge
- User Isolation: “Why is the CFO’s session slow, even though the system overall is fine?”
- Module Analysis: “Is the ‘Payroll’ module suffering from lock contention?”
- SQL Diagnosis: “What specific event is this SQL statement waiting on?”
Solution
This report aggregates ASH samples to estimate wait times for specific criteria.
Key Features:
- Granular Filtering: Can filter by
SESSION_TYPE,EVENT,INSTANCE_NUMBER, etc. - ASH Sampling: Uses the 1-second samples from ASH to reconstruct the performance profile.
- CPU vs. Wait: Clearly distinguishes between time spent working (CPU) and time spent waiting.
Architecture
The report queries DBA_HIST_ACTIVE_SESS_HISTORY.
Key Tables:
DBA_HIST_ACTIVE_SESS_HISTORY: The history of active sessions (sampled every 10 seconds).
Impact
- Targeted Tuning: Solves “needle in a haystack” problems where a single user or job is suffering.
- Multi-Tenant Analysis: In a consolidated environment, identifies which tenant is causing the noise.
- Forensic Analysis: Allows detailed post-mortem analysis of incidents that happened days ago.
Useful Links
- Blitz Report™ – World’s Fastest Oracle EBS Reporting Tool
- Oracle Discoverer Replacement – Import Worksheets into Blitz Report™
- Oracle EBS Reporting Toolkits by Blitz Report™
- Blitz Report™ FAQ & Community Q&A
- Supply Chain Hub by Blitz Report™
- Blitz Report™ Customer Case Studies
- Oracle EBS Reporting Blog
- Oracle EBS Reporting Resource Centre
© 2026 Enginatics