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