Note
- This variable is available starting with V4.3.3 BP1 in V4.3.x.
- This variable is available starting with V4.2.4 in V4.2.x.
Description
enable_sql_plan_monitor specifies whether to record SQL statements in the SQL plan monitor for the current session.
Privilege requirements
Query variables
systenant and all user tenants can execute theSHOW VARIABLESstatement or query theSYS.TENANT_VIRTUAL_SESSION_VARIABLEview (Oracle-compatible mode) or theinformation_schema.SESSION_VARIABLESview (MySQL-compatible mode) to obtain the values of session system variables.Modify variables
systenant and all user tenants can directly modify the values of session system variables in their own tenants.
Attributes
| Attribute | Description |
|---|---|
| Parameter type | Bool |
| Default value | False |
| Value range |
|
| Scope | Session |
| Modifiable | Yes. You can execute the SET statement to modify the value. |
Examples
Record all SQL statements in the current session in the SQL plan monitor.
obclient> SET enable_sql_plan_monitor =True;