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

# SESSIONIOS: Data Dictionary Session I/Os

`read only`

- Catalogue : `DataDictionary`
- Schéma : `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.

Permet uniquement de récupérer des données.

## Colonnes de table

Les colonnes de la table `SESSIONIOS` sont présentées ci-dessous. Chaque colonne possède un type de données SQL. Une nouvelle valeur non nulle doit être fournie pour chaque colonne requise à tout moment lors de l'insertion et de la mise à jour.

| Name | Type de données | Label | Required | Marks | Documentation |
|---|---|---|:---:|---|---|
| `ACTION` | `varchar2` | Action | [x] |  | Action, being either 'READ' or 'WRITE'. |
| `BILLING_ID` | `varchar2` | ID de facturation | [ ] |  | ID for billing. |
| `BILLING_POOL_IDENTITY_ID` | `varchar2` | Identifiant du groupe de facturation | [ ] |  | Pool identity ID for billing. |
| `BILLING_REFERENCE` | `varchar2` | Référence de facturation | [ ] |  | Reference for billing, such as your cost centers. |
| `BYTES_RECEIVED` | `int64` | Octets reçus | [ ] |  | Number of bytes received. |
| `BYTES_SENT` | `int64` | Octets envoyés | [ ] |  | Number of bytes sent. |
| `CACHE_ID` | `varchar2(1024)` | ID du cache | [ ] |  | Cache ID. |
| `CALL_SAFE_NAME` | `varchar2` | Nom de l'appel sécurisé | [ ] |  | Call safe name of the object. |
| `CLIENT_ID` | `varchar2(240)` | Id du client | [ ] |  | Client ID. |
| `DATA_CONTAINER_ALIAS` | `varchar2(240)` | Alias du conteneur de données | [ ] |  | Alias of the data container. |
| `DATA_CONTAINER_ID` | `varchar2` | ID du conteneur de données | [x] |  | ID of the data container. |
| `DURATION_CPU_MS` | `double` | Durée d'utilisation du processeur | [x] |  | CPU duration in milliseconds of the I/O. |
| `DURATION_IO_MS` | `double` | Durée des opérations d'E/S | [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` | Durée du sommeil | [x] |  | Sleep duration in milliseconds of the I/O. |
| `ERROR_MESSAGE` | `varchar2` | Message d'Erreur | [ ] |  | Error message that occurred during executing the I/O. |
| `ERROR_MESSAGE_CODE` | `varchar2` | Code du message d'erreur | [ ] |  | Error message code that occurred during executing the I/O. |
| `EXECUTION_END_DATE_UTC` | `datetime` | Date de fin d'exécution | [x] |  | Date at which the I/O was ended (UTC). |
| `EXECUTION_ID` | `guid` | ID d'exécution | [ ] |  | ID of the SQL execution. |
| `EXECUTION_START_DATE_UTC` | `datetime` | Date de début d'exécution | [x] |  | Date at which the I/O was started (UTC). |
| `EXECUTION_STEP_ID` | `int64` | ID de l'étape d'exécution SQL | [ ] |  | ID of the SQL execution step. |
| `FORWARDED_CUSTOMER_SERVICE` | `char` | Transmis au Customer Service | [x] |  | Indicator whether session I/O was forwarded. |
| `FROM_APPLICATION_CACHE` | `char` | À partir du cache d'application | [x] |  | Indicator whether the data was retrieved from application-specific cache. |
| `FROM_CACHE` | `char` | Depuis le cache | [x] |  | Indicator whether the data was retrieved from any cache. |
| `FROM_DISK_CACHE` | `char` | À partir du cache disque | [x] |  | Indicator whether the data was retrieved from disk cache. |
| `FROM_MEMORY_CACHE` | `char` | À partir du cache mémoire | [x] |  | Indicator whether the data was retrieved from memory cache. |
| `GUI_ACTION` | `varchar2(240)` | Action GUI | [ ] |  | Action performed within the user interface. |
| `GUI_MODULE_NAME` | `varchar2(240)` | Nom du module GUI | [ ] |  | Module within the GUI application currently running. |
| `GUI_MODULE_VERSION` | `varchar2(240)` | Version du module graphique | [ ] |  | 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` | Code du contrat de licence | [ ] |  | License contract code. |
| `LICENSE_KEY_IDENTIFIER` | `varchar2` | Identifiant de la clé de licence | [ ] |  | License key identifier. |
| `MANAGED_THREAD_ID` | `int32` | ID du fil géré | [ ] |  | 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` | Liste des paramètres | [ ] |  | Parameters. |
| `PARTITION` | `varchar2` | Partition | [ ] |  | Specific partition on which the I/O was executed. |
| `POOL_IDENTITY` | `varchar2(60)` | Identité du Pool | [ ] |  | Pool identity. |
| `PROCESS_ID` | `uint32` | ID du processus | [ ] |  | Process ID. |
| `PROVIDER_INSTANCE_UID` | `guid` | UID de l'instance du fournisseur | [ ] |  | Unique ID of the provider instance. |
| `PROVIDER_NAME` | `varchar2` | Provider | [x] |  | Name of provider. |
| `PUBLIC_QUERY_PARAMETERS` | `varchar2` | Paramètres de requête publique | [ ] |  | Parameters added to the platform query. |
| `RECURSION_LEVEL` | `int32` | Niveau de récursivité | [x] |  | Recursion level. |
| `REMOTE_CORRELATION_IDS` | `varchar2(1024)` | Identifiants de corrélation à distance | [ ] |  | Remote correlation IDs as a comma-separated list of key, colon, space and value. |
| `REQUEST_ID` | `varchar2(60)` | ID de demande | [ ] |  | Request ID. |
| `ROUND_TRIPS` | `int32` | Allers-retours | [ ] |  | 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` | ID de l'instruction SQL | [ ] |  | ID of the SQL statement. |
| `SUCCESSFUL` | `char` | Succesful | [x] |  | Indicator whether the I/O completed successfully. |
| `TASK_ID` | `int32` | ID de Tâche | [ ] |  | Task ID. |
| `UID` | `guid` | UID | [x] |  | Unique ID of the property. |
| `URL` | `varchar2` | URL | [ ] |  | Address being accessed. |

## Clés

| Key | Column | Se réfère à | 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. |


## Notes de Version

Quels ont été les changements apportés à chaque version au niveau des tables, des colonnes, des attributs et des fonctionnalités du chauffeur :

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