# ⏱️ AWR Wait Advisor Diagnostics Pack

Top 10 wait events and class breakdown from AWR last 7 days. Flags hard-parse ratio >10% and disk-sort spills >1%. Requires Oracle Diagnostics Pack license.

Connection:
Reading AWR wait event history…
DBA_HIST_SYSTEM_EVENT + DBA_HIST_SYSSTAT (last 7 days)
⏱️
Select a connection and click "Fetch"
Reads AWR history for the last 7 days. Requires Oracle Diagnostics Pack license (DBA_HIST_*).

### 🔒 Diagnostics Pack Required

AWR views require Oracle Diagnostics Pack license. Contact your DBA or license administrator.

Flags
Top 10 Wait Events (last 7 days, excl. Idle)
Wait Class Breakdown
Key System Statistics