Note
The default value of this variable has been changed from `120000000` to `86400000000` since OceanBase Database V4.0.0.
Description
ob_trx_idle_timeout specifies the idle timeout period in which no transactions are executed. A timeout error occurs if the execution interval between two consecutive statements exceeds the value of this variable.
Attributes
| Attribute | Description |
|---|---|
| Type | Integer |
| Default value | 86400000000, in microseconds |
| Value range | [100000000, +∞) |
| Effective scope | |
| Modifiable | Yes. You can use the SET statement to modify the variable. |
Examples
Set the variable at the session level
obclient> SET ob_trx_idle_timeout =86400000000;Set the variable at the global level
obclient> SET GLOBAL ob_trx_idle_timeout =86400000000;