LucidDbSysRoot KILL STATEMENT MATCH

Syntax

CALL SYS_ROOT.KILL_STATEMENT_MATCH( match_text [, cancel_only ] )

Purpose

Cancels any LucidDB statements whose SQL text contains a given string. See KILL_STATEMENT for details on killing an individual statement.

Parameters

• match_text: text to match [VARCHAR], which can be obtained via view DBA_SQL_STATEMENTS.
• cancel_only: [BOOLEAN] true to just abort; false (default) to destroy statements, releasing their resources

Example

-- list running statements to find the one tying up resources
SELECT stmt_id, sql_text FROM sys_root.dba_sql_statements;
+-------------+---------------------------------------------------------------+
| STMT_ID     |                           SQL_TEXT                            |
+-------------+---------------------------------------------------------------+
| 5           | select * from s.bench100 b1, s.bench100 b2 order by 1         |
| 8           | select session_id, sql_text from sys_root.dba_sql_statements  |
+-------------+---------------------------------------------------------------+

-- boot any statements referencing table bench100
CALL sys_root.kill_statement_match('bench100');