SYSCS_UTIL.SET_EXPLAIN_CONNECTION

Enables or disables capturing query execution plans and statistics for the current connection.

After enabling query execution plan capture, you can optionally enable statistics timing using SYSCS_UTIL.SET_STATISTICS_TIMING.

Enable query execution plan capture by calling this procedure with a non-zero argument. Disable capture by calling the procedure with a zero argument. See Capture Query Execution Plans for All Statements.

Syntax

SYSCS_UTIL.SET_EXPLAIN_CONNECTION(IN SMALLINT ENABLE)

Example

To begin capturing execution plans for the current connection:

CALL SYSCS_UTIL.SET_EXPLAIN_CONNECTION(1);