⏱️ 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