Note
This view is available starting with V4.2.0.
Purpose
This view displays the locks held or requested by the current user on all tables of the current OBServer node.
Columns
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.
|
| TYPE | varchar(9) | NO | The lock type.
|
| ID1 | bigint(20) | NO | The first lock identifier.
|
| ID2 | varchar(533) | NO | The second lock identifier.
|
| ID3 | varchar(512) | NO | The third lock identifier.
Note
|
| LMODE | varchar(8) | NO | The mode in which the lock is held.
|
| REQUEST | varchar(8) | NO | The mode in which the lock is requested.
|
| CTIME | bigint(20) | NO | The time for which the lock is held or for which 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.
|
Sample query
Query the locks held or requested by the current user on all tables of the current OBServer node.
obclient [oceanbase]> SELECT * FROM oceanbase.V$OB_LOCKS;
The query result is as follows:
+----------------+----------+-----------+----------+------------+------+---------+------------+------+-------+---------+---------+-------+
| SVR_IP | SVR_PORT | TENANT_ID | TRANS_ID | SESSION_ID | TYPE | ID1 | ID2 | ID3 | LMODE | REQUEST | CTIME | BLOCK |
+----------------+----------+-----------+----------+------------+------+---------+------------+------+-------+---------+---------+-------+
| 11.xxx.xxx.xxx | 28825 | 1002 | 3770799 | 3221509936 | TM | 3770297 | 4294967295 | NULL | NONE | N | 2302737 | 1 |
+----------------+----------+-----------+----------+------------+------+---------+------------+------+-------+---------+---------+-------+
1 row in set
References
For more information about how to lock a table, see Lock a table.