Note
This variable was introduced in OceanBase Database V4.1.0.
Description
ob_enable_show_trace specifies whether to enable trace logs.
Privilege requirements
Query the variable
In the
systenant or a user tenant, you can execute theSHOW VARIABLESstatement to query the variable at the session level or query theSYS.TENANT_VIRTUAL_SESSION_VARIABLEview (in Oracle mode) orinformation_schema.SESSION_VARIABLESview (in MySQL mode) for the variable at the session level.Modify the variable
In the
systenant or a user tenant, you can directly change the value of the variable at the session level for the current tenant.
Attributes
Attribute |
Description |
|---|---|
| Type | Boolean |
| Default value | 0 |
| Value range |
|
| Effective scope | Session |
| Modifiable | Yes. You can use the SET or ALTER SESSION SET statement to modify the variable. |
Examples
Enable trace logs.
obclient> SET ob_enable_show_trace = 1;