---
title: "SYSTEMPSQLLOCKS (Data Dictionary)"
description: "PSQL Locks"
language: de
source_language: en
translation_state: pending
canonical: https://documentation.invantive.eu/de/datamodels/datadictionary/DataDictionary.Invantive.SYSTEMPSQLLOCKS
original: https://documentation.invantive.eu/en/datamodels/datadictionary/DataDictionary.Invantive.SYSTEMPSQLLOCKS
updated: 2026-11-16T20:45:33Z
license: https://documentation.invantive.eu/de/
---

# 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 | [x] |  | 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 | [x] |  | Name of the PSQL lock (dbms_lock). |
| `WAITER_COUNT` | `int32` | Anzahl der Kellner | [x] |  | 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:

- [Data Dictionary](/de/release-notes/drivers?driver=data-dictionary)
