SYSTEMPSQLLOCKS: Data Dictionary PSQL Locks
read only
- Catalogus:
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.
Kan alleen gegevens ophalen.
Tabelkolommen
De kolommen van de tabel SYSTEMPSQLLOCKS worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype. Voor elke vereiste kolom moet bij het invoegen en bijwerken steeds een nieuwe, niet-lege waarde worden opgegeven.
| Name | Datatype | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
FIRST_ |
datetime |
Eerst Verworven (UTC) | Moment the lock was first acquired since the session created it.Lifetime statistic: a release does not clear it. | ||
FIRST_ |
datetime |
Eerste Wachter (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 |
Vastgehouden Aantal | Re-entrant hold count of the holding frame. | ||
LAST_ |
datetime |
Laatst Verworven (UTC) | Moment the lock was most recently acquired (hold count zero to one).Lifetime statistic: a release does not clear it. | ||
LAST_ |
datetime |
Laatste Wachter (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 |
Aantal Wachters | Number of frames currently waiting on the lock. |
Release Notes
Wat is er per release veranderd in de tabellen, kolommen, attributen en mogelijkheden van de driver: