Step 5: Session Management (Admin Role)

If you have admin rights, you can also:

• View active sessions (filter by username, SQL ID, and so on).
• Identify stuck or long-running sessions.
• Use the provided interface or API to terminate safe-to-kill sessions (based on naming patterns like _RDS_CUSTOM).

Table 23-2 Interpretation Tips

Observation	Likely Cause / Next Step
High wait time on temp I/O	Queries spilling to disk → check joins/sorts
One query dominates Top SQL	Regressed plan or unindexed access → tune it
Lots of queued statements	Resource bottleneck (e.g., CPU) → throttle, tune
Sharp spike in APEX load time	Backend slowness or DB resource saturation
Session count far above normal	Application surge, leaking sessions, or blocking