SESSIONIOS: Data Dictionary Session I/Os
read only
- Catalogus:
DataDictionary - Schema:
Invantive - Label: Session I/Os
Individual I/Os executed by Invantive's UniversalSQL engine on the data containers during the execution of SQL statements and their statistics.
Kan alleen gegevens ophalen.
Tabelkolommen
De kolommen van de tabel SESSIONIOS 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 |
|---|---|---|---|---|---|
ACTION |
varchar2 |
Action | Action, being either 'READ' or 'WRITE'. | ||
BILLING_ |
varchar2 |
Factuur ID | ID for billing. | ||
BILLING_ |
varchar2 |
Facturatiepool Identiteit-ID | Pool identity ID for billing. | ||
BILLING_ |
varchar2 |
Factuurreferentie | Reference for billing, such as your cost centers. | ||
BYTES_ |
int64 |
Bytes Ontvangen | Number of bytes received. | ||
BYTES_ |
int64 |
Bytes Verzonden | Number of bytes sent. | ||
CACHE_ |
varchar2 |
Cache-ID | Cache ID. | ||
CALL_ |
varchar2 |
Veilig Naam voor Aanroep | Call safe name of the object. | ||
CLIENT_ |
varchar2 |
Client-ID | Client ID. | ||
DATA_ |
varchar2 |
Datacontainer Alias | Alias of the data container. | ||
DATA_ |
varchar2 |
Datacontainer ID | ID of the data container. | ||
DURATION_ |
double |
CPU-duur | CPU duration in milliseconds of the I/O. | ||
DURATION_ |
double |
I/O-duur | I/O duration in milliseconds of the I/O. | ||
DURATION_ |
double |
Duration | Duration in milliseconds of the I/O. | ||
DURATION_ |
double |
Slaapduur | Sleep duration in milliseconds of the I/O. | ||
ERROR_ |
varchar2 |
Foutmelding | Error message that occurred during executing the I/O. | ||
ERROR_ |
varchar2 |
Foutmeldingcode | Error message code that occurred during executing the I/O. | ||
EXECUTION_ |
datetime |
Uitvoering Eind Datum | Date at which the I/O was ended (UTC). | ||
EXECUTION_ |
guid |
Uitvoerings-ID | ID of the SQL execution. | ||
EXECUTION_ |
datetime |
Startdatum van Uitvoering | Date at which the I/O was started (UTC). | ||
EXECUTION_ |
int64 |
SQL-Uitvoeringsstap-ID | ID of the SQL execution step. | ||
FORWARDED_ |
char |
Doorgestuurd naar Customer Service | Indicator whether session I/O was forwarded. | ||
FROM_ |
char |
Vanuit Applicatiecache | Indicator whether the data was retrieved from application-specific cache. | ||
FROM_ |
char |
Uit Cache | Indicator whether the data was retrieved from any cache. | ||
FROM_ |
char |
Vanuit Schijfcache | Indicator whether the data was retrieved from disk cache. | ||
FROM_ |
char |
Vanuit Geheugencache | Indicator whether the data was retrieved from memory cache. | ||
GUI_ |
varchar2 |
GUI-actie | Action performed within the user interface. | ||
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. | ||
ID |
int64 |
ID | Unique ID of the property. | ||
IIID |
varchar2 |
IIID | Invantive installation ID. | ||
IUID |
varchar2 |
IUID | Invantive user ID. | ||
LICENSE_ |
varchar2 |
Licentiecontractcode | License contract code. | ||
LICENSE_ |
varchar2 |
Licentiesleutel Identificatie | License key identifier. | ||
MANAGED_ |
int32 |
Beheerde Thread-ID | Managed thread ID. | ||
ORIGIN |
varchar2 |
Origin | Why the I/O was made: 'User' for a question asked, 'Metadata' for finding out what the platform holds, and 'Preemptive' for data fetched ahead of a question expected shortly. | ||
PARAMETER_ |
varchar2 |
Parameterlijst | Parameters. | ||
PARTITION |
varchar2 |
Partition | Specific partition on which the I/O was executed. | ||
POOL_ |
varchar2 |
Pool Identiteit | Pool identity. | ||
PROCESS_ |
uint32 |
Proces-ID | Process ID. | ||
PROVIDER_ |
guid |
Providerinstantie UID | Unique ID of the provider instance. | ||
PROVIDER_ |
varchar2 |
Provider | Name of provider. | ||
PUBLIC_ |
varchar2 |
Publieke Zoekparameters | Parameters added to the platform query. | ||
RECURSION_ |
int32 |
Recursieniveau | Recursion level. | ||
REMOTE_ |
varchar2 |
Externe Correlatie-ID's | Remote correlation IDs as a comma-separated list of key, colon, space and value. | ||
REQUEST_ |
varchar2 |
Verzoek ID | Request ID. | ||
ROUND_ |
int32 |
Rondgangen | Number of round trips. | ||
ROW_ |
int64 |
Rows | Number of rows exchanged. | ||
SESSION_ |
varchar2 |
Sessie ID | ID of the session. | ||
STATEMENT_ |
guid |
SQL-Statement ID | ID of the SQL statement. | ||
SUCCESSFUL |
char |
Succesful | Indicator whether the I/O completed successfully. | ||
TASK_ |
int32 |
Taak ID | Task ID. | ||
UID |
guid |
UID | Unique ID of the property. | ||
URL |
varchar2 |
URL | Address being accessed. |
Toetsen
| Key | Column | Verwijst naar | Kind | Description |
|---|---|---|---|---|
SESSIONIOS_ |
EXECUTION_ |
SYSTEMSQLEXECUTIONS.ID |
Textual | The execution of the statement, once it has been registered.A call is logged while the statement still runs and an execution is listed only after the statement has ended; a statement that fails or is cancelled registers none. |
SESSIONIOS_ |
EXECUTION_ |
SYSTEMSQLEXECUTIONSTEPS.ID |
Textual | The step of the execution, once the execution has been registered.The steps of a statement are listed only after it has ended; a call of a statement that fails or is cancelled names a step that is never listed. |
SESSIONIOS_ |
PROVIDER_ |
SYSTEMDATACONTAINERS. |
Textual | The data container of the call, while that data container is active; the history of calls outlives a data container that was closed. |
SESSIONIOS_ |
STATEMENT_ |
SYSTEMSQLAREA.ID |
Textual | The statement in the SQL area, once its query plan has statistics.A call of the first execution of a statement is logged before the SQL area lists the statement. |
Release Notes
Wat is er per release veranderd in de tabellen, kolommen, attributen en mogelijkheden van de driver: