SYSTEMLOCKS: Data Dictionary Locks
read only
- Catalogus:
DataDictionary - Schema:
Invantive - Label: Locks
Locks.
Kan alleen gegevens ophalen.
Tabelkolommen
De kolommen van de tabel SYSTEMLOCKS worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype. Voor elke vereiste kolom moet bij het invoegen en bijwerken steeds een nieuwe, niet-lege waarde worden opgegeven.
| Name | Datatype | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
ACQUISITION_ |
int64 |
Aantal Acquisities | Number of acquisitions. | ||
AVERAGE_ |
number |
Gemiddeld Actief | Average number of active slots. | ||
BILLING_ |
varchar2 |
Factuur ID | ID for billing. | ||
BILLING_ |
varchar2 |
Facturatie-ID Laatste Verwerving | ID for billing at last acquisition. | ||
BILLING_ |
varchar2 |
Facturatie-ID Laatste Time-out | ID for billing at last timeout. | ||
CALLING_ |
varchar2 |
Aanroepende Provider Alias | Calling provider alias. | ||
CATEGORY_ |
varchar2 |
Categoriecode | Category. | ||
CONTEXT |
varchar2 |
Context | Context. | ||
CURRENT_ |
int32 |
Momenteel Vrij | Current capacity free. | ||
CURRENT_ |
int32 |
Huidige Lezing | Current read capacity used. | ||
CURRENT_ |
int32 |
Momenteel Gebruikt | Current capacity used. | ||
CURRENT_ |
int32 |
Momenteel Wachtend | Current number of waiters. | ||
DATA_ |
varchar2 |
Datacontainer ID | Data container ID that created the lock. | ||
DATE_ |
datetime |
Eerste Verwerving | Time of first acquisition. | ||
DATE_ |
datetime |
Eerste Vrijgave | Time of first release. | ||
DATE_ |
datetime |
Eerste Time-out | Time of first time-out. | ||
DATE_ |
datetime |
Laatste Verwerving | Time of last acquisition. | ||
DATE_ |
datetime |
Laatste Volledige Verwerving | Time of last full release. | ||
DATE_ |
datetime |
Laatste Bewerking | Time of last operation. | ||
DATE_ |
datetime |
Laatste Release | Time of last release. | ||
DATE_ |
datetime |
Laatste Time-out | Time of last time-out. | ||
DATE_ |
datetime |
Registered | Time of registration. | ||
EXECUTION_ |
int64 |
SQL-Uitvoeringsstap-ID | ID of the SQL execution step that created the lock. | ||
GUI_ |
varchar2 |
GUI-actie | Action performed within the user interface. | ||
GUI_ |
varchar2 |
GUI Extern IP-adres | External IP address of the GUI application. | ||
GUI_ |
varchar2 |
GUI IP-adres Extern Laatste Verwerving | External IP address of the GUI application at last acquisition. | ||
GUI_ |
varchar2 |
GUI IP-adres Extern Laatste Time-out | External IP address of the GUI application at last timeout. | ||
GUI_ |
uint16 |
GUI IP-poort | External IP port of the GUI application. | ||
GUI_ |
uint16 |
GUI IP-poort Laatste Verwerving | External IP port of the GUI application at last acquisition. | ||
GUI_ |
uint16 |
GUI IP-poort Laatste Time-out | External IP port of the GUI application at last timeout. | ||
GUI_ |
varchar2 |
GUI-Machine | Name of the machine running the GUI application. | ||
GUI_ |
varchar2 |
GUI-Module Naam | Module within the GUI application currently running. | ||
GUI_ |
varchar2 |
GUI-Modules Versie | Version of module within the GUI application currently running. | ||
GUI_ |
varchar2 |
GUI-OS-Gebruiker | OS user. | ||
GUI_ |
varchar2 |
User | Application user. | ||
INITIAL_ |
int32 |
Initiële Capaciteit | Initial capacity. | ||
LAST_ |
varchar |
Code voor overnamecategorie | Category code of last acquisition. | ||
LAST_ |
varchar |
Volledige vrijgavecode | Category code of last full release. | ||
LAST_ |
varchar |
Code van de operatiecategorie | Category code of last operation. | ||
LAST_ |
varchar |
Code vrijgavecategorie | Category code of last release. | ||
LAST_ |
varchar |
Time-outcategorie-code | Category code of last timeout. | ||
LAST_ |
double |
Laatste Wachttijd Time-out (ms) | Time-out in milliseconds of last started and active wait. | ||
MAXIMUM_ |
int32 |
Maximale Capaciteit | Maximum capacity. | ||
PARTITION_ |
varchar2 |
Partitiecode | Unique code of the partition that created the lock. | ||
POOL_ |
varchar2 |
Pool Identiteit | Pool identity. | ||
POOL_ |
varchar2 |
Poolidentiteit Laatste Acquisitie | Pool identity at last acquisition. | ||
POOL_ |
varchar2 |
Poolidentiteit Laatste Time-out | Pool identity at last timeout. | ||
PROCESS_ |
uint32 |
Proces-ID | Process ID. | ||
PROVIDER_ |
varchar2 |
Providernaam | Name of the provider that created the lock. | ||
RELEASE_ |
int64 |
Vrijgavetelling | Number of releases. | ||
REQUEST_ |
varchar2 |
Verzoek ID | Request ID. | ||
REQUEST_ |
varchar2 |
Verzoek-ID Laatste Verwerving | Request ID at last acquisition. | ||
REQUEST_ |
varchar2 |
Verzoek-ID Laatste Time-out | Request ID at last timeout. | ||
SESSION_ |
varchar2 |
Sessie ID | ID of the session that created the lock. | ||
SQL_ |
varchar2 |
SQL-instructie | SQL statement that created the lock. | ||
STDDEV_ |
number |
Standaardafwijking Actief | Standard deviation number of active slots. | ||
STYLE |
varchar |
Style | Style. | ||
TABLE_ |
varchar2 |
Tabelnaam | Name of the table that created the lock. | ||
TIMEOUT_ |
int64 |
Aantal Time-outs | Number of timeouts. | ||
TYPE |
varchar2 |
Type | Type of lock.One of: SEMAPHORE or RWLOCK. | ||
UID |
guid |
UID | Unique ID. | ||
WAITS_ |
int64 |
Voltooide Wachtacties | Number of waits completed. | ||
WAIT_ |
double |
Gemiddelde Wachttijd (ms) | Average duration of wait (ms)). | ||
WAIT_ |
double |
Standaarddeviatie Wachttijd (ms) | Standard deviation duration of wait (ms)). |
Release Notes
Wat is er per release veranderd in de tabellen, kolommen, attributen en mogelijkheden van de driver: