V$OB_LOCKS|V5.0.1|OceanBase Database|docs|OceanBase Documentations

Column	Type	Nullable	Description
SVR_IP	varchar(46)	NO	The IP address of the OBServer node that holds or requests the lock.
SVR_PORT	bigint(20)	NO	The port number of the OBServer node that holds or requests the lock.
TENANT_ID	bigint(20)	NO	The ID of the tenant that holds or requests the lock.
TRANS_ID	bigint(20)	NO	The ID of the transaction that holds or requests the lock.
SESSION_ID	bigint(20)	NO	The ID of the session that holds or requests the lock In V4.3.x versions, this field is available starting from V4.3.2. In versions earlier than V4.3.5 BP2: This field indicates the server session ID in all connection modes (direct mode and ODP mode). In V4.3.5 BP2 and later: In direct mode: This field indicates the server session ID. In ODP mode: If the `client_session_id_version` parameter in ODP is set to 2, this field indicates the client session ID. If `client_session_id_version` is set to 1, this field indicates the server session ID. In V4.2.x versions, this field is available starting from V4.2.5. In all connection modes (direct mode and ODP mode), this field indicates the server session ID.
TYPE	varchar(9)	NO	The lock type. Valid values: TM: table lock TX: transaction lock TR: row lock
ID1	bigint(20)	NO	The lock identifier 1. Valid values: For a table lock: the value can be TABLE_ID or TABLET_ID. For a transaction lock: TX_ID. For a row lock: TABLET_ID.
ID2	varchar(533)	NO	The lock identifier 2. Valid values: For a table lock: NULL. For a transaction lock: NULL. For a row lock: TX_ID + rowkey.
ID3	varchar(512)	NO	The lock identifier 3. Valid values: For a table lock: TABLE_ID or TABLET_ID. For a transaction lock: NULL. For a row lock: TABLET_ID + rowkey. Note In V4.3.x versions, this field is available starting from V4.3.2. In V4.2.x versions, this field is available starting from V4.2.5.
LMODE	varchar(8)	NO	The mode of the lock that is held. Valid values: NONE: no lock is held. RS: ROW SHARE RX: ROW EXCLUSIVE S: SHARE SRX: SHARE ROW EXCLUSIVE X: EXCLUSIVE
REQUEST	varchar(8)	NO	The mode of the lock that is requested. Valid values: NONE: no lock is requested. RS: ROW SHARE RX: ROW EXCLUSIVE S: SHARE SRX: SHARE ROW EXCLUSIVE X: EXCLUSIVE
CTIME	bigint(20)	NO	The time when the lock is held or when the lock is being waited for, in microseconds.
BLOCK	bigint(1)	NO	Indicates whether the lock requested by the current transaction is held by another transaction. Valid values: 0: The lock is not held by another transaction. That is, the current transaction holds the lock. 1: The lock is held by another transaction. That is, the current transaction is blocked.

SVR_IP

varchar(46)

NO

The IP address of the OBServer node that holds or requests the lock.

SVR_PORT

bigint(20)

NO

The port number of the OBServer node that holds or requests the lock.

TENANT_ID

bigint(20)

NO

The ID of the tenant that holds or requests the lock.

TRANS_ID

bigint(20)

NO

The ID of the transaction that holds or requests the lock.

SESSION_ID

bigint(20)

NO

The ID of the session that holds or requests the lock

In V4.3.x versions, this field is available starting from V4.3.2.
- In versions earlier than V4.3.5 BP2:
  This field indicates the server session ID in all connection modes (direct mode and ODP mode).
- In V4.3.5 BP2 and later:
  - In direct mode:
    This field indicates the server session ID.
  - In ODP mode:
In V4.2.x versions, this field is available starting from V4.2.5. In all connection modes (direct mode and ODP mode), this field indicates the server session ID.

TYPE

varchar(9)

NO

The lock type. Valid values:

TM: table lock
TX: transaction lock
TR: row lock

ID1

bigint(20)

NO

The lock identifier 1. Valid values:

For a table lock: the value can be TABLE_ID or TABLET_ID.
For a transaction lock: TX_ID.
For a row lock: TABLET_ID.

ID2

varchar(533)

NO

The lock identifier 2. Valid values:

For a table lock: NULL.
For a transaction lock: NULL.
For a row lock: TX_ID + rowkey.

ID3

varchar(512)

NO

The lock identifier 3. Valid values:

For a table lock: TABLE_ID or TABLET_ID.
For a transaction lock: NULL.
For a row lock: TABLET_ID + rowkey.

Note

In V4.3.x versions, this field is available starting from V4.3.2.
In V4.2.x versions, this field is available starting from V4.2.5.

LMODE

varchar(8)

NO

The mode of the lock that is held. Valid values:

NONE: no lock is held.
RS: ROW SHARE
RX: ROW EXCLUSIVE
S: SHARE
SRX: SHARE ROW EXCLUSIVE
X: EXCLUSIVE

REQUEST

varchar(8)

NO

The mode of the lock that is requested. Valid values:

NONE: no lock is requested.
RS: ROW SHARE
RX: ROW EXCLUSIVE
S: SHARE
SRX: SHARE ROW EXCLUSIVE
X: EXCLUSIVE

CTIME

bigint(20)

NO

The time when the lock is held or when the lock is being waited for, in microseconds.

BLOCK

bigint(1)

NO

Indicates whether the lock requested by the current transaction is held by another transaction. Valid values:

0: The lock is not held by another transaction. That is, the current transaction holds the lock.
1: The lock is held by another transaction. That is, the current transaction is blocked.

V$OB_LOCKS

Note

Purpose

Columns

Note

Sample query

References