Note
This variable is available starting with V2.2.77.
Description
ob_proxy_set_trx_executed specifies whether to send the START TRANSACTION Syntax statement to the OBServer node through the OBProxy.
Attributes
| Attribute | Description |
|---|---|
| Type | Bool |
| Default value | 0 |
| Value range |
|
| Scope | Session |
| Modifiable | No. You can specify this variable when you create a tenant. After the tenant is created, you cannot modify the variable by executing an SQL statement. |
Usage notes
You cannot query the value of this variable by using the SHOW VARIABLES statement or the SYS.TENANT_VIRTUAL_SESSION_VARIABLE view in Oracle mode or the information_schema.SESSION_VARIABLES view in MySQL mode. You can query the value of this variable from the SYS.DBA_OB_SYS_VARIABLES view in Oracle mode or the oceanbase.DBA_OB_SYS_VARIABLES view in MySQL mode.
You can also query the value of this variable by using the SELECT statement:
obclient> SELECT @@ob_proxy_set_trx_executed;
The query result is as follows:
+-----------------------------+
| @@ob_proxy_set_trx_executed |
+-----------------------------+
| 0 |
+-----------------------------+
1 row in set