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

# SYSTEMLOCKS: Data Dictionary Locks

`read only`

- Katalog: `DataDictionary`
- Schema: `Invantive`
- Label: Locks

Locks.

Es können nur Daten abgerufen werden.

## Tabellenspalten

Die Spalten der Tabelle `SYSTEMLOCKS` 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 |
|---|---|---|:---:|---|---|
| `ACQUISITION_COUNT` | `int64` | Anzahl Akquisitionen | [x] |  | Number of acquisitions. |
| `AVERAGE_ACTIVE` | `number` | Durchschnittlich Aktiv | [x] |  | Average number of active slots. |
| `BILLING_ID` | `varchar2` | Rechnungs-ID | [ ] |  | ID for billing. |
| `BILLING_ID_LAST_ACQUISITION` | `varchar2` | Abrechnungs-ID Letzte Erfassung | [ ] |  | ID for billing at last acquisition. |
| `BILLING_ID_LAST_TIMEOUT` | `varchar2` | Abrechnungs-ID Letzte Zeitüberschreitung | [ ] |  | ID for billing at last timeout. |
| `CALLING_PROVIDER_ALIAS` | `varchar2(240)` | Anrufender Provider-Alias | [ ] |  | Calling provider alias. |
| `CATEGORY_CODE` | `varchar2` | Kategoriecode | [ ] |  | Category. |
| `CONTEXT` | `varchar2` | Context | [ ] |  | Context. |
| `CURRENT_FREE` | `int32` | Aktuell Frei | [x] |  | Current capacity free. |
| `CURRENT_READ_USED` | `int32` | Aktuelle Lektüre | [x] |  | Current read capacity used. |
| `CURRENT_USED` | `int32` | Aktuell verwendet | [x] |  | Current capacity used. |
| `CURRENT_WAITING_COUNT` | `int32` | Aktuelle Wartezeit | [x] |  | Current number of waiters. |
| `DATA_CONTAINER_ID` | `varchar2(4000)` | Datenkontainer ID | [ ] |  | Data container ID that created the lock. |
| `DATE_FIRST_ACQUISITION` | `datetime` | Erste Akquisition | [ ] |  | Time of first acquisition. |
| `DATE_FIRST_RELEASE` | `datetime` | Erste Freigabe | [ ] |  | Time of first release. |
| `DATE_FIRST_TIMEOUT` | `datetime` | Erstes Timeout | [ ] |  | Time of first time-out. |
| `DATE_LAST_ACQUISITION` | `datetime` | Letzte Akquisition | [ ] |  | Time of last acquisition. |
| `DATE_LAST_FULL_RELEASE` | `datetime` | Letzte vollständige Freigabe | [ ] |  | Time of last full release. |
| `DATE_LAST_OPERATION` | `datetime` | Letzter Vorgang | [x] |  | Time of last operation. |
| `DATE_LAST_RELEASE` | `datetime` | Letzte Veröffentlichung | [ ] |  | Time of last release. |
| `DATE_LAST_TIMEOUT` | `datetime` | Letzte Zeitüberschreitung | [ ] |  | Time of last time-out. |
| `DATE_REGISTERED` | `datetime` | Registered | [x] |  | Time of registration. |
| `EXECUTION_STEP_ID` | `int64` | SQL-Ausführungsschritt-ID | [ ] |  | ID of the SQL execution step that created the lock. |
| `GUI_ACTION` | `varchar2(240)` | GUI-Aktion | [ ] |  | Action performed within the user interface. |
| `GUI_IP_ADDRESS_EXTERNAL` | `varchar2(240)` | GUI Externe IP-Adresse | [ ] |  | External IP address of the GUI application. |
| `GUI_IP_ADDRESS_EXTERNAL_LAST_ACQUISITION` | `varchar2(240)` | GUI-IP-Adresse, extern, letzte Erfassung | [ ] |  | External IP address of the GUI application at last acquisition. |
| `GUI_IP_ADDRESS_EXTERNAL_LAST_TIMEOUT` | `varchar2(240)` | GUI-IP-Adresse, extern, letzte Zeitüberschreitung | [ ] |  | External IP address of the GUI application at last timeout. |
| `GUI_IP_PORT` | `uint16` | GUI-IP-Port | [ ] |  | External IP port of the GUI application. |
| `GUI_IP_PORT_LAST_ACQUISITION` | `uint16` | GUI, IP, Port, letzte Erfassung | [ ] |  | External IP port of the GUI application at last acquisition. |
| `GUI_IP_PORT_LAST_TIMEOUT` | `uint16` | GUI-IP-Port – Letzte Zeitüberschreitung | [ ] |  | External IP port of the GUI application at last timeout. |
| `GUI_MACHINE` | `varchar2(240)` | GUI Computer | [ ] |  | Name of the machine running the GUI application. |
| `GUI_MODULE_NAME` | `varchar2(240)` | Name des GUI-Moduls | [ ] |  | Module within the GUI application currently running. |
| `GUI_MODULE_VERSION` | `varchar2(240)` | GUI-Modul Version | [ ] |  | Version of module within the GUI application currently running. |
| `GUI_OS_USER` | `varchar2(240)` | GUI-OS-Benutzer | [ ] |  | OS user. |
| `GUI_USER` | `varchar2(240)` | User | [ ] |  | Application user. |
| `INITIAL_CAPACITY` | `int32` | Anfängliche Kapazität | [x] |  | Initial capacity. |
| `LAST_ACQUISITION_CATEGORY_CODE` | `varchar(60)` | Code der Beschaffungskategorie | [ ] |  | Category code of last acquisition. |
| `LAST_FULL_RELEASE_CATEGORY_CODE` | `varchar(60)` | Vollständige Freigabe – Kategorie-Code | [ ] |  | Category code of last full release. |
| `LAST_OPERATION_CATEGORY_CODE` | `varchar(60)` | Code der Betriebskategorie | [ ] |  | Category code of last operation. |
| `LAST_RELEASE_CATEGORY_CODE` | `varchar(60)` | Kategorie-Code für die Veröffentlichung | [ ] |  | Category code of last release. |
| `LAST_TIMEOUT_CATEGORY_CODE` | `varchar(60)` | Timeout-Kategorie-Code | [ ] |  | Category code of last timeout. |
| `LAST_WAIT_TIMEOUT_MS` | `double` | Letzte Wartezeit (ms) | [ ] |  | Time-out in milliseconds of last started and active wait. |
| `MAXIMUM_CAPACITY` | `int32` | Maximale Kapazität | [x] |  | Maximum capacity. |
| `PARTITION_CODE` | `varchar2(240)` | Partitionscode | [ ] |  | Unique code of the partition that created the lock. |
| `POOL_IDENTITY` | `varchar2(60)` | Pool-Identität | [ ] |  | Pool identity. |
| `POOL_IDENTITY_LAST_ACQUISITION` | `varchar2(60)` | Pool-Identität – Letzter Erwerb | [ ] |  | Pool identity at last acquisition. |
| `POOL_IDENTITY_LAST_TIMEOUT` | `varchar2(60)` | Pool-Identität – Letzte Zeitüberschreitung | [ ] |  | Pool identity at last timeout. |
| `PROCESS_ID` | `uint32` | Prozess-ID | [ ] |  | Process ID. |
| `PROVIDER_NAME` | `varchar2(240)` | Anbietername | [ ] |  | Name of the provider that created the lock. |
| `RELEASE_COUNT` | `int64` | Anzahl Veröffentlichungen | [x] |  | Number of releases. |
| `REQUEST_ID` | `varchar2(240)` | ID der Anfrage | [ ] |  | Request ID. |
| `REQUEST_ID_LAST_ACQUISITION` | `varchar2(240)` | Anfrage-ID Letzte Erfassung | [ ] |  | Request ID at last acquisition. |
| `REQUEST_ID_LAST_TIMEOUT` | `varchar2(240)` | Anfrage-ID – Letzte Zeitüberschreitung | [ ] |  | Request ID at last timeout. |
| `SESSION_ID` | `varchar2(240)` | Session-ID | [ ] |  | ID of the session that created the lock. |
| `SQL_STATEMENT` | `varchar2` | SQL Anweisung | [ ] |  | SQL statement that created the lock. |
| `STDDEV_ACTIVE` | `number` | Standardabweichung aktiv | [x] |  | Standard deviation number of active slots. |
| `STYLE` | `varchar(60)` | Style | [x] |  | Style. |
| `TABLE_NAME` | `varchar2` | Tabelle Name | [ ] |  | Name of the table that created the lock. |
| `TIMEOUT_COUNT` | `int64` | Anzahl der Timeouts | [x] |  | Number of timeouts. |
| `TYPE` | `varchar2(30)` | Type | [ ] |  | Type of lock.One of: SEMAPHORE or RWLOCK. |
| `UID` | `guid` | UID | [x] |  | Unique ID. |
| `WAITS_COMPLETED` | `int64` | Wartezeiten abgeschlossen | [x] |  | Number of waits completed. |
| `WAIT_AVERAGE_DURATION_MS` | `double` | Durchschnittliche Wartezeit (ms) | [x] |  | Average duration of wait (ms)). |
| `WAIT_STDDEV_DURATION_MS` | `double` | Standardabweichung der Wartezeit (ms) | [x] |  | Standard deviation duration of wait (ms)). |


## 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)
