Step 3: Triage with "Top SQL"

Navigate to:

DB Ops Console -> Top SQL

• Identify SQLs that are frequently active or waiting.
• Filter by session state: ON CPU vs. WAITING.
• Click into a SQL ID to view execution details and full text.

This is your quickest path to confirm which queries are stressing the system now, even outside the AWR snapshot window.