invantive documentation
Invantive SupportforenAnmelden / Eintragen

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 Number of acquisitions.
AVERAGE_ACTIVE number Durchschnittlich Aktiv 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 Current capacity free.
CURRENT_READ_USED int32 Aktuelle Lektüre Current read capacity used.
CURRENT_USED int32 Aktuell verwendet Current capacity used.
CURRENT_WAITING_COUNT int32 Aktuelle Wartezeit 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 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 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 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 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 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 Standard deviation number of active slots.
STYLE varchar(60) Style Style.
TABLE_NAME varchar2 Tabelle Name Name of the table that created the lock.
TIMEOUT_COUNT int64 Anzahl der Timeouts Number of timeouts.
TYPE varchar2(30) Type Type of lock.One of: SEMAPHORE or RWLOCK.
UID guid UID Unique ID.
WAITS_COMPLETED int64 Wartezeiten abgeschlossen Number of waits completed.
WAIT_AVERAGE_DURATION_MS double Durchschnittliche Wartezeit (ms) Average duration of wait (ms)).
WAIT_STDDEV_DURATION_MS double Standardabweichung der Wartezeit (ms) 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: