# SYSTEMPSQLLOCKS: Data Dictionary System PSQL locks Named PSQL locks of the session (dbms_lock). Fully released locks stay listed with their lifetime statistics, bounded to the 10,000 most recently released; locks currently held or waited on are always listed. - Catalog: `DataDictionary` - Schema: `Invantive` - Alias: `plk` - Label: System PSQL locks This is a read-only view. The Data Dictionary API may not support changing the data or the Invantive UniversalSQL driver for Data Dictionary does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Data Dictionary API. ## View Columns The columns of the view `SYSTEMPSQLLOCKS` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `FIRST_ACQUIRED_UTC` | `datetime` | First acquired (UTC) | ☐ | Moment the lock was first acquired since the session created it. Lifetime statistic: a release does not clear it. | | `FIRST_WAITER_UTC` | `datetime` | First waiter (UTC) | ☐ | Moment a frame first started waiting on the lock. Lifetime statistic. | | `HOLD_COUNT` | `int32` | Hold count | ☑ | Re-entrant hold count of the holding frame. | | `HOLDER_DESCRIPTION` | `varchar2` | Holder | ☐ | Description of the worker frame holding the lock: a parallel branch, a parallel loop worker or the main frame. Empty when free. | | `LAST_ACQUIRED_UTC` | `datetime` | Last acquired (UTC) | ☐ | Moment the lock was most recently acquired (hold count zero to one). Lifetime statistic: a release does not clear it. | | `LAST_WAITER_UTC` | `datetime` | Last waiter (UTC) | ☐ | Moment a frame most recently started waiting on the lock. Lifetime statistic. | | `NAME` | `varchar2` | Name | ☑ | Name of the PSQL lock (dbms_lock). | | `WAITER_COUNT` | `int32` | Waiter count | ☑ | Number of frames currently waiting on the lock. |