OceanBaseデータベース

SQL - V4.4.2

PDF をダウンロード

このページには現在中国語/日本語版がなく、英語版を表示しています。

ob_trx_lock_timeout

最終更新:2026-09-03 07:31:09

Note

This variable is available starting with V2.2.77.

Description

ob_trx_lock_timeout specifies the lock wait timeout for a transaction.

Privilege requirements

Query variables
- Global level
  
  sys tenant and all user tenants can execute the SHOW VARIABLES statement or query the SYS.TENANT_VIRTUAL_GLOBAL_VARIABLE view (Oracle mode) or the information_schema.GLOBAL_VARIABLES view (MySQL mode) to obtain the value of a global system variable.
- Session level
  
  sys tenant and all user tenants can execute the SHOW VARIABLES statement or query the SYS.TENANT_VIRTUAL_SESSION_VARIABLE view (Oracle mode) or the information_schema.SESSION_VARIABLES view (MySQL mode) to obtain the value of a session system variable.
Modify variables
- Global level
  - sys tenant can directly modify the value of a global system variable.
  - MySQL user tenants must have the SUPER or ALTER SYSTEM privilege to modify the value of a global system variable.
  - Oracle user tenants must have the ALTER SYSTEM privilege to modify the value of a global system variable.
- Session level
  
  sys tenant and all user tenants can directly modify the value of a session system variable.

Attributes

Attribute	Description
Type	int
Default value	-1, indicating that the lock wait timeout is not enabled. The unit is microseconds.
Value range	[0,+∞) Note A value of 0 indicates NO WAIT.
Scope	Global Session
Modifiable	Yes. You can execute the `SET` statement to modify the value.

Examples

Session level

obclient> SET ob_trx_lock_timeout = 3000;

Global level

obclient> SET GLOBAL ob_trx_lock_timeout = 3000;

References

次のトピック

ob_trx_lock_timeout|V4.6.0|OceanBase Database|docs|OceanBase Documentations