---
title: "SESSIONIOS (Data Dictionary)"
description: "Session I/Os"
language: en
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/en/datamodels/datadictionary/DataDictionary.Invantive.SESSIONIOS
original: https://documentation.invantive.eu/en/datamodels/datadictionary/DataDictionary.Invantive.SESSIONIOS
updated: 2026-11-01T16:08:19Z
license: https://documentation.invantive.eu/en/
---

# SESSIONIOS: Data Dictionary Session I/Os

`read only`

- Catalog: `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.

Can only retrieve data.

## Table Columns

The columns of the table `SESSIONIOS` are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

| Name | Data Type | Label | Required | Marks | Documentation |
|---|---|---|:---:|---|---|
| `ACTION` | `varchar2` | Action | [x] |  | Action, being either 'READ' or 'WRITE'. |
| `BILLING_ID` | `varchar2` | Billing ID | [ ] |  | ID for billing. |
| `BILLING_POOL_IDENTITY_ID` | `varchar2` | Billing Pool Identity ID | [ ] |  | Pool identity ID for billing. |
| `BILLING_REFERENCE` | `varchar2` | Billing Reference | [ ] |  | Reference for billing, such as your cost centers. |
| `BYTES_RECEIVED` | `int64` | Bytes Received | [ ] |  | Number of bytes received. |
| `BYTES_SENT` | `int64` | Bytes Sent | [ ] |  | Number of bytes sent. |
| `CACHE_ID` | `varchar2(1024)` | Cache ID | [ ] |  | Cache ID. |
| `CALL_SAFE_NAME` | `varchar2` | Call Safe Name | [ ] |  | Call safe name of the object. |
| `CLIENT_ID` | `varchar2(240)` | Client ID | [ ] |  | Client ID. |
| `DATA_CONTAINER_ALIAS` | `varchar2(240)` | Data Container Alias | [ ] |  | Alias of the data container. |
| `DATA_CONTAINER_ID` | `varchar2` | Data Container ID | [x] |  | ID of the data container. |
| `DURATION_CPU_MS` | `double` | CPU Duration | [x] |  | CPU duration in milliseconds of the I/O. |
| `DURATION_IO_MS` | `double` | I/O Duration | [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` | Sleep Duration | [x] |  | Sleep duration in milliseconds of the I/O. |
| `ERROR_MESSAGE` | `varchar2` | Error Message | [ ] |  | Error message that occurred during executing the I/O. |
| `ERROR_MESSAGE_CODE` | `varchar2` | Error Message Code | [ ] |  | Error message code that occurred during executing the I/O. |
| `EXECUTION_END_DATE_UTC` | `datetime` | Execution End Date | [x] |  | Date at which the I/O was ended (UTC). |
| `EXECUTION_ID` | `guid` | Execution ID | [ ] |  | ID of the SQL execution. |
| `EXECUTION_START_DATE_UTC` | `datetime` | Execution Start Date | [x] |  | Date at which the I/O was started (UTC). |
| `EXECUTION_STEP_ID` | `int64` | SQL Execution Step ID | [ ] |  | ID of the SQL execution step. |
| `FORWARDED_CUSTOMER_SERVICE` | `char` | Forwarded to Customer Service | [x] |  | Indicator whether session I/O was forwarded. |
| `FROM_APPLICATION_CACHE` | `char` | From Application Cache | [x] |  | Indicator whether the data was retrieved from application-specific cache. |
| `FROM_CACHE` | `char` | From Cache | [x] |  | Indicator whether the data was retrieved from any cache. |
| `FROM_DISK_CACHE` | `char` | From Disk Cache | [x] |  | Indicator whether the data was retrieved from disk cache. |
| `FROM_MEMORY_CACHE` | `char` | From Memory Cache | [x] |  | Indicator whether the data was retrieved from memory cache. |
| `GUI_ACTION` | `varchar2(240)` | GUI Action | [ ] |  | Action performed within the user interface. |
| `GUI_MODULE_NAME` | `varchar2(240)` | GUI Module Name | [ ] |  | Module within the GUI application currently running. |
| `GUI_MODULE_VERSION` | `varchar2(240)` | GUI Module Version | [ ] |  | 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` | License Contract Code | [ ] |  | License contract code. |
| `LICENSE_KEY_IDENTIFIER` | `varchar2` | License Key Identifier | [ ] |  | License key identifier. |
| `MANAGED_THREAD_ID` | `int32` | Managed 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` | Parameter List | [ ] |  | Parameters. |
| `PARTITION` | `varchar2` | Partition | [ ] |  | Specific partition on which the I/O was executed. |
| `POOL_IDENTITY` | `varchar2(60)` | Pool Identity | [ ] |  | Pool identity. |
| `PROCESS_ID` | `uint32` | Process ID | [ ] |  | Process ID. |
| `PROVIDER_INSTANCE_UID` | `guid` | Provider Instance UID | [ ] |  | Unique ID of the provider instance. |
| `PROVIDER_NAME` | `varchar2` | Provider | [x] |  | Name of provider. |
| `PUBLIC_QUERY_PARAMETERS` | `varchar2` | Public Query Parameters | [ ] |  | Parameters added to the platform query. |
| `RECURSION_LEVEL` | `int32` | Recursion Level | [x] |  | Recursion level. |
| `REMOTE_CORRELATION_IDS` | `varchar2(1024)` | Remote Correlation IDs | [ ] |  | Remote correlation IDs as a comma-separated list of key, colon, space and value. |
| `REQUEST_ID` | `varchar2(60)` | Request ID | [ ] |  | Request ID. |
| `ROUND_TRIPS` | `int32` | Round Trips | [ ] |  | Number of round trips. |
| `ROW_COUNT` | `int64` | Rows | [ ] |  | Number of rows exchanged. |
| `SESSION_ID` | `varchar2(240)` | Session 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` | Task ID | [ ] |  | Task ID. |
| `UID` | `guid` | UID | [x] |  | Unique ID of the property. |
| `URL` | `varchar2` | URL | [ ] |  | Address being accessed. |

## Keys

| Key | Column | Refers to | 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

What changed per release in the tables, columns, attributes and capabilities of the driver:

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

