SYSTEMPSQLLOCKS: Data Dictionary PSQL Locks
read only
- Catalog:
DataDictionary - Schema:
Invantive - Label: 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.
Can only retrieve data.
Table Columns
The columns of the table SYSTEMPSQLLOCKS are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.
| Name | Data Type | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
FIRST_ |
datetime |
First Acquired (UTC) | Moment the lock was first acquired since the session created it. Lifetime statistic: a release does not clear it. | ||
FIRST_ |
datetime |
First Waiter (UTC) | Moment a frame first started waiting on the lock. Lifetime statistic. | ||
HOLDER_ |
varchar2 |
Holder | Description of the worker frame holding the lock: a parallel branch, a parallel loop worker or the main frame. Empty when free. | ||
HOLD_ |
int32 |
Hold Count | Re-entrant hold count of the holding frame. | ||
LAST_ |
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_ |
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_ |
int32 |
Waiter Count | Number of frames currently waiting on the lock. |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: