Purpose
GV$LOCK displays the row locks of an OceanBase database.
Fields
| Field | Type | Nullable? | Description |
|---|---|---|---|
| SVR_IP | varchar(32) | NO | The IP address of the server. |
| SVR_PORT | NUMBER(38) | NO | The port number of the server. |
| TABLE_ID | NUMBER(38) | NO | The ID of the table. |
| ADDR | varchar(512) | NO | The address of the locked object. |
| KADDR | NUMBER(38) | NO | The address of the lock. |
| SID | NUMBER(38) | NO | The ID of the session. |
| TYPE | NUMBER(38) | NO | 0 (row lock) |
| LMODE | NUMBER(38) | NO | 0 (write lock) |
| REQUEST | NUMBER | YES | Null |
| CTIME | NUMBER(38) | NO | The time spent on acquiring a row lock. |
| BLOCK | NUMBER(38) | NO | The ID of the earliest blocked session. |
| CON_ID | VARCHAR2(256) | NO | The ID of the tenant. |