invantive documentation
Invantive SupportforenAnmelden / Eintragen

SYSTEMPSQLLOCKS: Data Dictionary PSQL Locks

read only

  • Katalog: 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.

Es können nur Daten abgerufen werden.

Tabellenspalten

Die Spalten der Tabelle SYSTEMPSQLLOCKS sind unten aufgeführt. Jede Spalte hat einen SQL-Datentyp. Beim Einfügen und Aktualisieren muss für jede erforderliche Spalte jederzeit ein neuer Wert angegeben werden der nicht Null ist.

Name Datentyp Label Required Marks Documentation
FIRST_ACQUIRED_UTC datetime Erstmaliger Erwerb (UTC) Moment the lock was first acquired since the session created it.Lifetime statistic: a release does not clear it.
FIRST_WAITER_UTC datetime Erster Kellner (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 Anzahl der Haltevorgänge Re-entrant hold count of the holding frame.
LAST_ACQUIRED_UTC datetime Zuletzt erworben (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 Letzter Kellner (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 Anzahl der Kellner Number of frames currently waiting on the lock.

Anmerkungen zu dieser Version

Was hat sich in den Tabellen, Spalten, Attributen und Funktionen des Treibers mit jeder neuen Version geändert: