Purpose
The DBMS_LOCK_ALLOCATED view displays information about requested database management system (DBMS) locks that have not expired yet.
Note
This view is introduced since OceanBase Database V4.2.1.
Columns
Column |
Type |
Nullable? |
Description |
|---|---|---|---|
| NAME | VARCHAR2(128) | NO | The name of the lock |
| LOCKID | NUMBER(38) | NO | The ID of the lock. |
| EXPIRATION | TIMESTAMP(6) WITH LOCAL TIME ZONE | NO | The expiration time of the lock. |