enable_sql_plan_monitor

Last Updated:2026-09-03 07:31:11

Description

enable_sql_plan_monitor specifies whether to record SQL statements in the SQL plan monitor for the current session.

Query variables

sys tenant and all user tenants can execute the SHOW VARIABLES statement or query the SYS.TENANT_VIRTUAL_SESSION_VARIABLE view (Oracle-compatible mode) or the information_schema.SESSION_VARIABLES view (MySQL-compatible mode) to obtain the values of session system variables.
Modify variables

sys tenant and all user tenants can directly modify the values of session system variables in their own tenants.

Attribute	Description
Parameter type	Bool
Default value	False
Value range	False: The SQL statements in the current session are recorded in the SQL plan monitor only if any of the following conditions is met: The specific hint is used to enable the monitor. The SQL execution time exceeds the preset threshold. The SQL execution uses parallel processing with a degree of parallelism greater than 1. True: All SQL statements executed in the current session are automatically recorded in the SQL plan monitor without any additional conditions.
Scope	Session
Modifiable	Yes. You can execute the `SET` statement to modify the value.

Record all SQL statements in the current session in the SQL plan monitor.

obclient> SET  enable_sql_plan_monitor =True;

Previous topic

Next topic