Note
This view is available starting with V4.2.1.
Purpose
This view displays information about DBMS_LOCK requests that have been made and have not expired.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| NAME | VARCHAR2(128) | NO | The name of the lock. Primary Key |
| LOCKID | NUMBER(38) | NO | The ID of the lock. |
| EXPIRATION | TIMESTAMP(6) WITH LOCAL TIME ZONE | NO | The expiration time of the lock. |
Sample query
Query the DBMS_LOCK requests that have been made and have 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