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_ |
int64 |
Anzahl Akquisitionen | Number of acquisitions. | ||
AVERAGE_ |
number |
Durchschnittlich Aktiv | Average number of active slots. | ||
BILLING_ |
varchar2 |
Rechnungs-ID | ID for billing. | ||
BILLING_ |
varchar2 |
Abrechnungs-ID Letzte Erfassung | ID for billing at last acquisition. | ||
BILLING_ |
varchar2 |
Abrechnungs-ID Letzte Zeitüberschreitung | ID for billing at last timeout. | ||
CALLING_ |
varchar2 |
Anrufender Provider-Alias | Calling provider alias. | ||
CATEGORY_ |
varchar2 |
Kategoriecode | Category. | ||
CONTEXT |
varchar2 |
Context | Context. | ||
CURRENT_ |
int32 |
Aktuell Frei | Current capacity free. | ||
CURRENT_ |
int32 |
Aktuelle Lektüre | Current read capacity used. | ||
CURRENT_ |
int32 |
Aktuell verwendet | Current capacity used. | ||
CURRENT_ |
int32 |
Aktuelle Wartezeit | Current number of waiters. | ||
DATA_ |
varchar2 |
Datenkontainer ID | Data container ID that created the lock. | ||
DATE_ |
datetime |
Erste Akquisition | Time of first acquisition. | ||
DATE_ |
datetime |
Erste Freigabe | Time of first release. | ||
DATE_ |
datetime |
Erstes Timeout | Time of first time-out. | ||
DATE_ |
datetime |
Letzte Akquisition | Time of last acquisition. | ||
DATE_ |
datetime |
Letzte vollständige Freigabe | Time of last full release. | ||
DATE_ |
datetime |
Letzter Vorgang | Time of last operation. | ||
DATE_ |
datetime |
Letzte Veröffentlichung | Time of last release. | ||
DATE_ |
datetime |
Letzte Zeitüberschreitung | Time of last time-out. | ||
DATE_ |
datetime |
Registered | Time of registration. | ||
EXECUTION_ |
int64 |
SQL-Ausführungsschritt-ID | ID of the SQL execution step that created the lock. | ||
GUI_ |
varchar2 |
GUI-Aktion | Action performed within the user interface. | ||
GUI_ |
varchar2 |
GUI Externe IP-Adresse | External IP address of the GUI application. | ||
GUI_ |
varchar2 |
GUI-IP-Adresse, extern, letzte Erfassung | External IP address of the GUI application at last acquisition. | ||
GUI_ |
varchar2 |
GUI-IP-Adresse, extern, letzte Zeitüberschreitung | External IP address of the GUI application at last timeout. | ||
GUI_ |
uint16 |
GUI-IP-Port | External IP port of the GUI application. | ||
GUI_ |
uint16 |
GUI, IP, Port, letzte Erfassung | External IP port of the GUI application at last acquisition. | ||
GUI_ |
uint16 |
GUI-IP-Port – Letzte Zeitüberschreitung | External IP port of the GUI application at last timeout. | ||
GUI_ |
varchar2 |
GUI Computer | Name of the machine running the GUI application. | ||
GUI_ |
varchar2 |
Name des GUI-Moduls | Module within the GUI application currently running. | ||
GUI_ |
varchar2 |
GUI-Modul Version | Version of module within the GUI application currently running. | ||
GUI_ |
varchar2 |
GUI-OS-Benutzer | OS user. | ||
GUI_ |
varchar2 |
User | Application user. | ||
INITIAL_ |
int32 |
Anfängliche Kapazität | Initial capacity. | ||
LAST_ |
varchar |
Code der Beschaffungskategorie | Category code of last acquisition. | ||
LAST_ |
varchar |
Vollständige Freigabe – Kategorie-Code | Category code of last full release. | ||
LAST_ |
varchar |
Code der Betriebskategorie | Category code of last operation. | ||
LAST_ |
varchar |
Kategorie-Code für die Veröffentlichung | Category code of last release. | ||
LAST_ |
varchar |
Timeout-Kategorie-Code | Category code of last timeout. | ||
LAST_ |
double |
Letzte Wartezeit (ms) | Time-out in milliseconds of last started and active wait. | ||
MAXIMUM_ |
int32 |
Maximale Kapazität | Maximum capacity. | ||
PARTITION_ |
varchar2 |
Partitionscode | Unique code of the partition that created the lock. | ||
POOL_ |
varchar2 |
Pool-Identität | Pool identity. | ||
POOL_ |
varchar2 |
Pool-Identität – Letzter Erwerb | Pool identity at last acquisition. | ||
POOL_ |
varchar2 |
Pool-Identität – Letzte Zeitüberschreitung | Pool identity at last timeout. | ||
PROCESS_ |
uint32 |
Prozess-ID | Process ID. | ||
PROVIDER_ |
varchar2 |
Anbietername | Name of the provider that created the lock. | ||
RELEASE_ |
int64 |
Anzahl Veröffentlichungen | Number of releases. | ||
REQUEST_ |
varchar2 |
ID der Anfrage | Request ID. | ||
REQUEST_ |
varchar2 |
Anfrage-ID Letzte Erfassung | Request ID at last acquisition. | ||
REQUEST_ |
varchar2 |
Anfrage-ID – Letzte Zeitüberschreitung | Request ID at last timeout. | ||
SESSION_ |
varchar2 |
Session-ID | ID of the session that created the lock. | ||
SQL_ |
varchar2 |
SQL Anweisung | SQL statement that created the lock. | ||
STDDEV_ |
number |
Standardabweichung aktiv | Standard deviation number of active slots. | ||
STYLE |
varchar |
Style | Style. | ||
TABLE_ |
varchar2 |
Tabelle Name | Name of the table that created the lock. | ||
TIMEOUT_ |
int64 |
Anzahl der Timeouts | Number of timeouts. | ||
TYPE |
varchar2 |
Type | Type of lock.One of: SEMAPHORE or RWLOCK. | ||
UID |
guid |
UID | Unique ID. | ||
WAITS_ |
int64 |
Wartezeiten abgeschlossen | Number of waits completed. | ||
WAIT_ |
double |
Durchschnittliche Wartezeit (ms) | Average duration of wait (ms)). | ||
WAIT_ |
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: