Overview
V$LOCK displays the row lock information of the OceanBase database.
Field description
| Field name | Type | Nullable | Description |
|---|---|---|---|
| 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. |