LucidDbSysRoot KILL SESSION

Syntax

CALL SYS_ROOT.KILL_SESSION( session_id [, cancel_only ] )

Purpose

Cancels a LucidDB session, aborting any active statements associated with it. If cancel_only is false (the default), also destroys the session, first waiting for all statements to respond to the cancel request and finish executing. If cancel_only is true, returns immediately (not waiting for aborts to complete).

Parameters

• session_id: session ID [BIGINT], which can be obtained via view SYS_ROOT.DBA_SESSIONS or DBA_SQL_STATEMENTS.
• cancel_only: [BOOLEAN] true to just abort active statements; false (default) to destroy session

Example

-- list running statements to find session tying up resources
SELECT session_id, sql_text FROM sys_root.dba_sql_statements;
+-------------+---------------------------------------------------------------+
| SESSION_ID  |                           SQL_TEXT                            |
+-------------+---------------------------------------------------------------+
| 2           | select * from s.bench100 b1, s.bench100 b2 order by 1         |
| 3           | select session_id, sql_text from sys_root.dba_sql_statements  |
+-------------+---------------------------------------------------------------+

-- give 'em the boot
CALL sys_root.kill_session(2);