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_ |
datetime |
Erstmaliger Erwerb (UTC) | Moment the lock was first acquired since the session created it.Lifetime statistic: a release does not clear it. | ||
FIRST_ |
datetime |
Erster Kellner (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 |
Anzahl der Haltevorgänge | Re-entrant hold count of the holding frame. | ||
LAST_ |
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_ |
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_ |
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: