---
title: "SESSIONIOS (Data Dictionary)"
description: "Session I/Os"
language: nl
source_language: en
translation_state: pending
canonical: https://documentation.invantive.eu/nl/datamodels/datadictionary/DataDictionary.Invantive.SESSIONIOS
original: https://documentation.invantive.eu/en/datamodels/datadictionary/DataDictionary.Invantive.SESSIONIOS
updated: 2026-11-16T20:44:54Z
license: https://documentation.invantive.eu/nl/
---

# 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 | [x] |  | Action, being either 'READ' or 'WRITE'. |
| `BILLING_ID` | `varchar2` | Factuur ID | [ ] |  | ID for billing. |
| `BILLING_POOL_IDENTITY_ID` | `varchar2` | Facturatiepool Identiteit-ID | [ ] |  | Pool identity ID for billing. |
| `BILLING_REFERENCE` | `varchar2` | Factuurreferentie | [ ] |  | Reference for billing, such as your cost centers. |
| `BYTES_RECEIVED` | `int64` | Bytes Ontvangen | [ ] |  | Number of bytes received. |
| `BYTES_SENT` | `int64` | Bytes Verzonden | [ ] |  | Number of bytes sent. |
| `CACHE_ID` | `varchar2(1024)` | Cache-ID | [ ] |  | Cache ID. |
| `CALL_SAFE_NAME` | `varchar2` | Veilig Naam voor Aanroep | [ ] |  | Call safe name of the object. |
| `CLIENT_ID` | `varchar2(240)` | Client-ID | [ ] |  | Client ID. |
| `DATA_CONTAINER_ALIAS` | `varchar2(240)` | Datacontainer Alias | [ ] |  | Alias of the data container. |
| `DATA_CONTAINER_ID` | `varchar2` | Datacontainer ID | [x] |  | ID of the data container. |
| `DURATION_CPU_MS` | `double` | CPU-duur | [x] |  | CPU duration in milliseconds of the I/O. |
| `DURATION_IO_MS` | `double` | I/O-duur | [x] |  | I/O duration in milliseconds of the I/O. |
| `DURATION_MS` | `double` | Duration | [x] |  | Duration in milliseconds of the I/O. |
| `DURATION_SLEEP_MS` | `double` | Slaapduur | [x] |  | Sleep duration in milliseconds of the I/O. |
| `ERROR_MESSAGE` | `varchar2` | Foutmelding | [ ] |  | Error message that occurred during executing the I/O. |
| `ERROR_MESSAGE_CODE` | `varchar2` | Foutmeldingcode | [ ] |  | Error message code that occurred during executing the I/O. |
| `EXECUTION_END_DATE_UTC` | `datetime` | Uitvoering Eind Datum | [x] |  | Date at which the I/O was ended (UTC). |
| `EXECUTION_ID` | `guid` | Uitvoerings-ID | [ ] |  | ID of the SQL execution. |
| `EXECUTION_START_DATE_UTC` | `datetime` | Startdatum van Uitvoering | [x] |  | Date at which the I/O was started (UTC). |
| `EXECUTION_STEP_ID` | `int64` | SQL-Uitvoeringsstap-ID | [ ] |  | ID of the SQL execution step. |
| `FORWARDED_CUSTOMER_SERVICE` | `char` | Doorgestuurd naar Customer Service | [x] |  | Indicator whether session I/O was forwarded. |
| `FROM_APPLICATION_CACHE` | `char` | Vanuit Applicatiecache | [x] |  | Indicator whether the data was retrieved from application-specific cache. |
| `FROM_CACHE` | `char` | Uit Cache | [x] |  | Indicator whether the data was retrieved from any cache. |
| `FROM_DISK_CACHE` | `char` | Vanuit Schijfcache | [x] |  | Indicator whether the data was retrieved from disk cache. |
| `FROM_MEMORY_CACHE` | `char` | Vanuit Geheugencache | [x] |  | Indicator whether the data was retrieved from memory cache. |
| `GUI_ACTION` | `varchar2(240)` | GUI-actie | [ ] |  | Action performed within the user interface. |
| `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. |
| `ID` | `int64` | ID | [x] |  | Unique ID of the property. |
| `IIID` | `varchar2` | IIID | [ ] |  | Invantive installation ID. |
| `IUID` | `varchar2` | IUID | [ ] |  | Invantive user ID. |
| `LICENSE_CONTRACT_CODE` | `varchar2` | Licentiecontractcode | [ ] |  | License contract code. |
| `LICENSE_KEY_IDENTIFIER` | `varchar2` | Licentiesleutel Identificatie | [ ] |  | License key identifier. |
| `MANAGED_THREAD_ID` | `int32` | Beheerde Thread-ID | [ ] |  | Managed thread ID. |
| `ORIGIN` | `varchar2(32)` | Origin | [x] |  | 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_LIST` | `varchar2` | Parameterlijst | [ ] |  | Parameters. |
| `PARTITION` | `varchar2` | Partition | [ ] |  | Specific partition on which the I/O was executed. |
| `POOL_IDENTITY` | `varchar2(60)` | Pool Identiteit | [ ] |  | Pool identity. |
| `PROCESS_ID` | `uint32` | Proces-ID | [ ] |  | Process ID. |
| `PROVIDER_INSTANCE_UID` | `guid` | Providerinstantie UID | [ ] |  | Unique ID of the provider instance. |
| `PROVIDER_NAME` | `varchar2` | Provider | [x] |  | Name of provider. |
| `PUBLIC_QUERY_PARAMETERS` | `varchar2` | Publieke Zoekparameters | [ ] |  | Parameters added to the platform query. |
| `RECURSION_LEVEL` | `int32` | Recursieniveau | [x] |  | Recursion level. |
| `REMOTE_CORRELATION_IDS` | `varchar2(1024)` | Externe Correlatie-ID's | [ ] |  | Remote correlation IDs as a comma-separated list of key, colon, space and value. |
| `REQUEST_ID` | `varchar2(60)` | Verzoek ID | [ ] |  | Request ID. |
| `ROUND_TRIPS` | `int32` | Rondgangen | [ ] |  | Number of round trips. |
| `ROW_COUNT` | `int64` | Rows | [ ] |  | Number of rows exchanged. |
| `SESSION_ID` | `varchar2(240)` | Sessie ID | [x] |  | ID of the session. |
| `STATEMENT_ID` | `guid` | SQL-Statement ID | [ ] |  | ID of the SQL statement. |
| `SUCCESSFUL` | `char` | Succesful | [x] |  | Indicator whether the I/O completed successfully. |
| `TASK_ID` | `int32` | Taak ID | [ ] |  | Task ID. |
| `UID` | `guid` | UID | [x] |  | Unique ID of the property. |
| `URL` | `varchar2` | URL | [ ] |  | Address being accessed. |

## Toetsen

| Key | Column | Verwijst naar | Kind | Description |
|---|---|---|---|---|
| `SESSIONIOS_EXECUTION_ID_SYSTEMSQLEXECUTIONS_txt` | `EXECUTION_ID` | [SYSTEMSQLEXECUTIONS](DataDictionary.Invantive.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_STEP_ID_SYSTEMSQLEXECUTIONSTEPS_txt` | `EXECUTION_STEP_ID` | [SYSTEMSQLEXECUTIONSTEPS](DataDictionary.Invantive.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_INSTANCE_UID_SYSTEMDATACONTAINERS_txt` | `PROVIDER_INSTANCE_UID` | [SYSTEMDATACONTAINERS](DataDictionary.Invantive.SYSTEMDATACONTAINERS)`.PROVIDER_INSTANCE_UID` | 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_ID_SYSTEMSQLAREA_txt` | `STATEMENT_ID` | [SYSTEMSQLAREA](DataDictionary.Invantive.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:

- [Data Dictionary](/nl/release-notes/drivers?driver=data-dictionary)
