Note
This view is available starting with V4.2.1.
Purpose
This view displays information about DBMS_LOCK that has been applied for and has not expired.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| NAME | VARCHAR2(128) | NO | The lock name. Primary Key. |
| LOCKID | NUMBER(38) | NO | The lock ID. |
| EXPIRATION | TIMESTAMP(6) WITH LOCAL TIME ZONE | NO | The lock expiration time. |
Sample query
Query information about DBMS_LOCK that has been applied for and has not expired in the current tenant.
obclient[SYS]> SELECT * FROM SYS.DBMS_LOCK_ALLOCATED;
The query result is as follows:
+--------+------------+------------------------------+
| NAME | LOCKID | EXPIRATION |
+--------+------------+------------------------------+
| test01 | 1074054503 | 08-MAY-25 03.40.32.552443 PM |
+--------+------------+------------------------------+
1 row in set