Purpose
gv$lock displays the row locks of the OceanBase database.
Fields
| Field | Type | Nullable? | Description |
|---|---|---|---|
| SVR_IP | varchar(32) | NO | Server IP |
| SVR_PORT | bigint(20) | NO | The port number of the server. |
| TABLE_ID | bigint(20) | NO | The ID of the table. |
| ADDR | varchar(512) | NO | The address of the locked object. |
| KADDR | bigint(20) unsigned | NO | The address of the lock. |
| SID | bigint(20) | NO | The ID of the session. |
| TYPE | bigint(20) | NO | 0 (row lock) |
| LMODE | bigint(20) | NO | 0 (write lock) |
| REQUEST | bigint(0) | YES | NULL |
| CTIME | BIGINT(21) | NO | The time spent on acquiring a row lock. |
| BLOCK | bigint(20) | NO | The ID of the earliest blocked session. |
| CON_ID | bigint(20) unsigned | NO | The ID of the tenant. |