invantive documentation
Invantive Support ForumsAanmelden / Inschrijven

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_ACQUIRED_UTC datetime Eerst Verworven (UTC) Moment the lock was first acquired since the session created it.Lifetime statistic: a release does not clear it.
FIRST_WAITER_UTC datetime Eerste Wachter (UTC) Moment a frame first started waiting on the lock.Lifetime statistic.
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.
HOLD_COUNT int32 Vastgehouden Aantal Re-entrant hold count of the holding frame.
LAST_ACQUIRED_UTC 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_WAITER_UTC 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_COUNT 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: