invantive documentation
Invantive Support ForumsAanmelden / Inschrijven

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_COUNT int64 Aantal Acquisities Number of acquisitions.
AVERAGE_ACTIVE number Gemiddeld Actief Average number of active slots.
BILLING_ID varchar2 Factuur ID ID for billing.
BILLING_ID_LAST_ACQUISITION varchar2 Facturatie-ID Laatste Verwerving ID for billing at last acquisition.
BILLING_ID_LAST_TIMEOUT varchar2 Facturatie-ID Laatste Time-out ID for billing at last timeout.
CALLING_PROVIDER_ALIAS varchar2(240) Aanroepende Provider Alias Calling provider alias.
CATEGORY_CODE varchar2 Categoriecode Category.
CONTEXT varchar2 Context Context.
CURRENT_FREE int32 Momenteel Vrij Current capacity free.
CURRENT_READ_USED int32 Huidige Lezing Current read capacity used.
CURRENT_USED int32 Momenteel Gebruikt Current capacity used.
CURRENT_WAITING_COUNT int32 Momenteel Wachtend Current number of waiters.
DATA_CONTAINER_ID varchar2(4000) Datacontainer ID Data container ID that created the lock.
DATE_FIRST_ACQUISITION datetime Eerste Verwerving Time of first acquisition.
DATE_FIRST_RELEASE datetime Eerste Vrijgave Time of first release.
DATE_FIRST_TIMEOUT datetime Eerste Time-out Time of first time-out.
DATE_LAST_ACQUISITION datetime Laatste Verwerving Time of last acquisition.
DATE_LAST_FULL_RELEASE datetime Laatste Volledige Verwerving Time of last full release.
DATE_LAST_OPERATION datetime Laatste Bewerking Time of last operation.
DATE_LAST_RELEASE datetime Laatste Release Time of last release.
DATE_LAST_TIMEOUT datetime Laatste Time-out Time of last time-out.
DATE_REGISTERED datetime Registered Time of registration.
EXECUTION_STEP_ID int64 SQL-Uitvoeringsstap-ID ID of the SQL execution step that created the lock.
GUI_ACTION varchar2(240) GUI-actie Action performed within the user interface.
GUI_IP_ADDRESS_EXTERNAL varchar2(240) GUI Extern IP-adres External IP address of the GUI application.
GUI_IP_ADDRESS_EXTERNAL_LAST_ACQUISITION varchar2(240) GUI IP-adres Extern Laatste Verwerving External IP address of the GUI application at last acquisition.
GUI_IP_ADDRESS_EXTERNAL_LAST_TIMEOUT varchar2(240) GUI IP-adres Extern Laatste Time-out External IP address of the GUI application at last timeout.
GUI_IP_PORT uint16 GUI IP-poort External IP port of the GUI application.
GUI_IP_PORT_LAST_ACQUISITION uint16 GUI IP-poort Laatste Verwerving External IP port of the GUI application at last acquisition.
GUI_IP_PORT_LAST_TIMEOUT uint16 GUI IP-poort Laatste Time-out External IP port of the GUI application at last timeout.
GUI_MACHINE varchar2(240) GUI-Machine Name of the machine running the GUI application.
GUI_MODULE_NAME varchar2(240) GUI-Module Naam Module within the GUI application currently running.
GUI_MODULE_VERSION varchar2(240) GUI-Modules Versie Version of module within the GUI application currently running.
GUI_OS_USER varchar2(240) GUI-OS-Gebruiker OS user.
GUI_USER varchar2(240) User Application user.
INITIAL_CAPACITY int32 Initiële Capaciteit Initial capacity.
LAST_ACQUISITION_CATEGORY_CODE varchar(60) Code voor overnamecategorie Category code of last acquisition.
LAST_FULL_RELEASE_CATEGORY_CODE varchar(60) Volledige vrijgavecode Category code of last full release.
LAST_OPERATION_CATEGORY_CODE varchar(60) Code van de operatiecategorie Category code of last operation.
LAST_RELEASE_CATEGORY_CODE varchar(60) Code vrijgavecategorie Category code of last release.
LAST_TIMEOUT_CATEGORY_CODE varchar(60) Time-outcategorie-code Category code of last timeout.
LAST_WAIT_TIMEOUT_MS double Laatste Wachttijd Time-out (ms) Time-out in milliseconds of last started and active wait.
MAXIMUM_CAPACITY int32 Maximale Capaciteit Maximum capacity.
PARTITION_CODE varchar2(240) Partitiecode Unique code of the partition that created the lock.
POOL_IDENTITY varchar2(60) Pool Identiteit Pool identity.
POOL_IDENTITY_LAST_ACQUISITION varchar2(60) Poolidentiteit Laatste Acquisitie Pool identity at last acquisition.
POOL_IDENTITY_LAST_TIMEOUT varchar2(60) Poolidentiteit Laatste Time-out Pool identity at last timeout.
PROCESS_ID uint32 Proces-ID Process ID.
PROVIDER_NAME varchar2(240) Providernaam Name of the provider that created the lock.
RELEASE_COUNT int64 Vrijgavetelling Number of releases.
REQUEST_ID varchar2(240) Verzoek ID Request ID.
REQUEST_ID_LAST_ACQUISITION varchar2(240) Verzoek-ID Laatste Verwerving Request ID at last acquisition.
REQUEST_ID_LAST_TIMEOUT varchar2(240) Verzoek-ID Laatste Time-out Request ID at last timeout.
SESSION_ID varchar2(240) Sessie ID ID of the session that created the lock.
SQL_STATEMENT varchar2 SQL-instructie SQL statement that created the lock.
STDDEV_ACTIVE number Standaardafwijking Actief Standard deviation number of active slots.
STYLE varchar(60) Style Style.
TABLE_NAME varchar2 Tabelnaam Name of the table that created the lock.
TIMEOUT_COUNT int64 Aantal Time-outs Number of timeouts.
TYPE varchar2(30) Type Type of lock.One of: SEMAPHORE or RWLOCK.
UID guid UID Unique ID.
WAITS_COMPLETED int64 Voltooide Wachtacties Number of waits completed.
WAIT_AVERAGE_DURATION_MS double Gemiddelde Wachttijd (ms) Average duration of wait (ms)).
WAIT_STDDEV_DURATION_MS 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: