---
title: "SESSIONIOS (Data Dictionary)"
description: "Session I/Os"
language: de
source_language: en
translation_state: pending
canonical: https://documentation.invantive.eu/de/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/de/
---

# SESSIONIOS: Data Dictionary Session I/Os

`read only`

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

Es können nur Daten abgerufen werden.

## Tabellenspalten

Die Spalten der Tabelle `SESSIONIOS` sind unten aufgeführt. Jede Spalte hat einen SQL-Datentyp. Beim Einfügen und Aktualisieren muss für jede erforderliche Spalte jederzeit ein neuer Wert angegeben werden der nicht Null ist.

| Name | Datentyp | Label | Required | Marks | Documentation |
|---|---|---|:---:|---|---|
| `ACTION` | `varchar2` | Action | [x] |  | Action, being either 'READ' or 'WRITE'. |
| `BILLING_ID` | `varchar2` | Rechnungs-ID | [ ] |  | ID for billing. |
| `BILLING_POOL_IDENTITY_ID` | `varchar2` | Abrechnungspool-Identitäts-ID | [ ] |  | Pool identity ID for billing. |
| `BILLING_REFERENCE` | `varchar2` | Rechnungsreferenz | [ ] |  | Reference for billing, such as your cost centers. |
| `BYTES_RECEIVED` | `int64` | Bytes empfangen | [ ] |  | Number of bytes received. |
| `BYTES_SENT` | `int64` | Bytes gesendet | [ ] |  | Number of bytes sent. |
| `CACHE_ID` | `varchar2(1024)` | Cache-ID | [ ] |  | Cache ID. |
| `CALL_SAFE_NAME` | `varchar2` | Anruf Sicherer Name | [ ] |  | Call safe name of the object. |
| `CLIENT_ID` | `varchar2(240)` | Client-ID | [ ] |  | Client ID. |
| `DATA_CONTAINER_ALIAS` | `varchar2(240)` | Datencontaineralias | [ ] |  | Alias of the data container. |
| `DATA_CONTAINER_ID` | `varchar2` | Datenkontainer ID | [x] |  | ID of the data container. |
| `DURATION_CPU_MS` | `double` | CPU-Dauer | [x] |  | CPU duration in milliseconds of the I/O. |
| `DURATION_IO_MS` | `double` | I/O-Dauer | [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` | Schlafdauer | [x] |  | Sleep duration in milliseconds of the I/O. |
| `ERROR_MESSAGE` | `varchar2` | Fehlermeldung | [ ] |  | Error message that occurred during executing the I/O. |
| `ERROR_MESSAGE_CODE` | `varchar2` | Fehlermeldungscode | [ ] |  | Error message code that occurred during executing the I/O. |
| `EXECUTION_END_DATE_UTC` | `datetime` | Ausführungsenddatum | [x] |  | Date at which the I/O was ended (UTC). |
| `EXECUTION_ID` | `guid` | Ausführungs-ID | [ ] |  | ID of the SQL execution. |
| `EXECUTION_START_DATE_UTC` | `datetime` | Ausführungsstartdatum | [x] |  | Date at which the I/O was started (UTC). |
| `EXECUTION_STEP_ID` | `int64` | SQL-Ausführungsschritt-ID | [ ] |  | ID of the SQL execution step. |
| `FORWARDED_CUSTOMER_SERVICE` | `char` | Weitergeleitet an Customer Service | [x] |  | Indicator whether session I/O was forwarded. |
| `FROM_APPLICATION_CACHE` | `char` | Aus Anwendungscache | [x] |  | Indicator whether the data was retrieved from application-specific cache. |
| `FROM_CACHE` | `char` | Aus Cache | [x] |  | Indicator whether the data was retrieved from any cache. |
| `FROM_DISK_CACHE` | `char` | Aus Festplatten-Cache | [x] |  | Indicator whether the data was retrieved from disk cache. |
| `FROM_MEMORY_CACHE` | `char` | Aus Speichercache | [x] |  | Indicator whether the data was retrieved from memory cache. |
| `GUI_ACTION` | `varchar2(240)` | GUI-Aktion | [ ] |  | Action performed within the user interface. |
| `GUI_MODULE_NAME` | `varchar2(240)` | Name des GUI-Moduls | [ ] |  | Module within the GUI application currently running. |
| `GUI_MODULE_VERSION` | `varchar2(240)` | GUI-Modul 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` | Lizenzvertragscode | [ ] |  | License contract code. |
| `LICENSE_KEY_IDENTIFIER` | `varchar2` | ID des Lizenzschlüssels | [ ] |  | License key identifier. |
| `MANAGED_THREAD_ID` | `int32` | Verwaltete 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` | Parameterliste | [ ] |  | Parameters. |
| `PARTITION` | `varchar2` | Partition | [ ] |  | Specific partition on which the I/O was executed. |
| `POOL_IDENTITY` | `varchar2(60)` | Pool-Identität | [ ] |  | Pool identity. |
| `PROCESS_ID` | `uint32` | Prozess-ID | [ ] |  | Process ID. |
| `PROVIDER_INSTANCE_UID` | `guid` | Treiber Instanz-UID | [ ] |  | Unique ID of the provider instance. |
| `PROVIDER_NAME` | `varchar2` | Provider | [x] |  | Name of provider. |
| `PUBLIC_QUERY_PARAMETERS` | `varchar2` | Öffentliche Abfrageparameter | [ ] |  | Parameters added to the platform query. |
| `RECURSION_LEVEL` | `int32` | Rekursionsstufe | [x] |  | Recursion level. |
| `REMOTE_CORRELATION_IDS` | `varchar2(1024)` | Remote-Korrelations-IDs | [ ] |  | Remote correlation IDs as a comma-separated list of key, colon, space and value. |
| `REQUEST_ID` | `varchar2(60)` | ID der Anfrage | [ ] |  | 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-Anweisungs-ID | [ ] |  | ID of the SQL statement. |
| `SUCCESSFUL` | `char` | Succesful | [x] |  | Indicator whether the I/O completed successfully. |
| `TASK_ID` | `int32` | Aufgaben-ID | [ ] |  | Task ID. |
| `UID` | `guid` | UID | [x] |  | Unique ID of the property. |
| `URL` | `varchar2` | URL | [ ] |  | Address being accessed. |

## Tasten

| Key | Column | Bezieht sich auf | 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. |


## Anmerkungen zu dieser Version

Was hat sich in den Tabellen, Spalten, Attributen und Funktionen des Treibers mit jeder neuen Version geändert:

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