Purpose
gv$lock_wait_stat displays the status of row locks in the whole cluster.
Related tables/views
oceanbase.__all_virtual_lock_wait_stat
Fields
| Field | Type | Nullable? | Description |
|---|---|---|---|
| TENANT_ID | bigint(20) | NO | The ID of the tenant. |
| TABLE_ID | bigint(20) | NO | The ID of the table. |
| TABLE_NAME | varchar(128) | NO | The name of the table. |
| ROWKEY | varchar(512) | NO | The primary key of the table. |
| SVR_IP | varchar(32) | NO | The IP address. |
| SVR_PORT | bigint(20) | NO | The port number. |
| SESSION_ID | bigint(20) | NO | The session ID. |
| NEED_WAIT | tinyint(4) | NO | Indicates whether it is necessary to wait for the lock on the row modified by the statement. |
| RECV_TS | bigint(20) | NO | The timestamp of when the request was received. |
| LOCK_TS | bigint(20) | NO | The timestamp of when the last time a row was locked. |
| ABS_TIMEOUT | bigint(20) | NO | The time when the request timed out. |
| TRY_LOCK_TIMES | bigint(20) | NO | The number of locking attempts. |
| TIME_AFTER_RECV | bigint(20) | NO | The amount of time elapsed since the request was received. |