Control Sessions

Manage and control active database sessions including terminating runaway queries, resolving blocking situations, and handling problematic sessions to maintain system health.

Instructions

When to Use This Skill

• Runaway query consuming excessive resources
• Session is blocking critical work
• User requests to kill their own stuck session
• Emergency situation requires immediate session termination
• Unresponsive or hung sessions need cleanup

Available MCP Tools

• show_sessions - View all active sessions
• show_sql - Review SQL for specific session
• terminate_session - Kill a specific session
• detect_blocking - Identify blocking sessions
• show_top_consumers - Find resource-heavy sessions