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

# SESSIONIOS: Data Dictionary Session I/Os

`read only`

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

È possibile solo recuperare i dati.

## Colonne della tabella

Di seguito sono riportate le colonne della tabella `SESSIONIOS`. Ogni colonna ha un tipo di dati SQL. Un nuovo valore non nullo deve essere fornito per ogni colonna richiesta in ogni momento durante l'inserimento e l'aggiornamento.

| Name | Tipo di dati | Label | Required | Marks | Documentation |
|---|---|---|:---:|---|---|
| `ACTION` | `varchar2` | Action | [x] |  | Action, being either 'READ' or 'WRITE'. |
| `BILLING_ID` | `varchar2` | ID di fatturazione | [ ] |  | ID for billing. |
| `BILLING_POOL_IDENTITY_ID` | `varchar2` | ID identità del pool di fatturazione | [ ] |  | Pool identity ID for billing. |
| `BILLING_REFERENCE` | `varchar2` | Riferimento di fatturazione | [ ] |  | Reference for billing, such as your cost centers. |
| `BYTES_RECEIVED` | `int64` | Byte ricevuti | [ ] |  | Number of bytes received. |
| `BYTES_SENT` | `int64` | Byte inviati | [ ] |  | Number of bytes sent. |
| `CACHE_ID` | `varchar2(1024)` | ID della memoria | [ ] |  | Cache ID. |
| `CALL_SAFE_NAME` | `varchar2` | Nome sicuro di chiamata | [ ] |  | Call safe name of the object. |
| `CLIENT_ID` | `varchar2(240)` | ID del cliente | [ ] |  | Client ID. |
| `DATA_CONTAINER_ALIAS` | `varchar2(240)` | Alias del contenitore di dati | [ ] |  | Alias of the data container. |
| `DATA_CONTAINER_ID` | `varchar2` | ID di contenitore di dati | [x] |  | ID of the data container. |
| `DURATION_CPU_MS` | `double` | Durata della CPU | [x] |  | CPU duration in milliseconds of the I/O. |
| `DURATION_IO_MS` | `double` | Durata I/O | [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` | Durata del sonno | [x] |  | Sleep duration in milliseconds of the I/O. |
| `ERROR_MESSAGE` | `varchar2` | Messaggio di errore | [ ] |  | Error message that occurred during executing the I/O. |
| `ERROR_MESSAGE_CODE` | `varchar2` | Codice del messaggio di errore | [ ] |  | Error message code that occurred during executing the I/O. |
| `EXECUTION_END_DATE_UTC` | `datetime` | Data fine esecuzione | [x] |  | Date at which the I/O was ended (UTC). |
| `EXECUTION_ID` | `guid` | ID di esecuzione | [ ] |  | ID of the SQL execution. |
| `EXECUTION_START_DATE_UTC` | `datetime` | Data di inizio dell'esecuzione | [x] |  | Date at which the I/O was started (UTC). |
| `EXECUTION_STEP_ID` | `int64` | ID del passaggio di esecuzione SQL | [ ] |  | ID of the SQL execution step. |
| `FORWARDED_CUSTOMER_SERVICE` | `char` | Inoltrato al Customer Service | [x] |  | Indicator whether session I/O was forwarded. |
| `FROM_APPLICATION_CACHE` | `char` | Dalla cache dell'applicazione | [x] |  | Indicator whether the data was retrieved from application-specific cache. |
| `FROM_CACHE` | `char` | Da Cache | [x] |  | Indicator whether the data was retrieved from any cache. |
| `FROM_DISK_CACHE` | `char` | Dalla cache del disco | [x] |  | Indicator whether the data was retrieved from disk cache. |
| `FROM_MEMORY_CACHE` | `char` | Dalla memoria cache | [x] |  | Indicator whether the data was retrieved from memory cache. |
| `GUI_ACTION` | `varchar2(240)` | Azione GUI | [ ] |  | Action performed within the user interface. |
| `GUI_MODULE_NAME` | `varchar2(240)` | Nome del modulo GUI | [ ] |  | Module within the GUI application currently running. |
| `GUI_MODULE_VERSION` | `varchar2(240)` | Versione del modulo GUI | [ ] |  | 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` | Codice del contratto di licenza | [ ] |  | License contract code. |
| `LICENSE_KEY_IDENTIFIER` | `varchar2` | Identificatore della chiave di licenza | [ ] |  | License key identifier. |
| `MANAGED_THREAD_ID` | `int32` | ID thread gestito | [ ] |  | 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` | Elenco dei parametri | [ ] |  | Parameters. |
| `PARTITION` | `varchar2` | Partition | [ ] |  | Specific partition on which the I/O was executed. |
| `POOL_IDENTITY` | `varchar2(60)` | Identità del pool | [ ] |  | Pool identity. |
| `PROCESS_ID` | `uint32` | ID del processo | [ ] |  | Process ID. |
| `PROVIDER_INSTANCE_UID` | `guid` | UID dell'istanza del provider | [ ] |  | Unique ID of the provider instance. |
| `PROVIDER_NAME` | `varchar2` | Provider | [x] |  | Name of provider. |
| `PUBLIC_QUERY_PARAMETERS` | `varchar2` | Parametri di interrogazione pubblica | [ ] |  | Parameters added to the platform query. |
| `RECURSION_LEVEL` | `int32` | Livello di ricorsione | [x] |  | Recursion level. |
| `REMOTE_CORRELATION_IDS` | `varchar2(1024)` | ID di correlazione remoti | [ ] |  | Remote correlation IDs as a comma-separated list of key, colon, space and value. |
| `REQUEST_ID` | `varchar2(60)` | ID richiesta | [ ] |  | Request ID. |
| `ROUND_TRIPS` | `int32` | Viaggi di andata e ritorno | [ ] |  | Number of round trips. |
| `ROW_COUNT` | `int64` | Rows | [ ] |  | Number of rows exchanged. |
| `SESSION_ID` | `varchar2(240)` | Identificatore di sessione | [x] |  | ID of the session. |
| `STATEMENT_ID` | `guid` | ID dell'istruzione SQL | [ ] |  | ID of the SQL statement. |
| `SUCCESSFUL` | `char` | Succesful | [x] |  | Indicator whether the I/O completed successfully. |
| `TASK_ID` | `int32` | ID compito | [ ] |  | Task ID. |
| `UID` | `guid` | UID | [x] |  | Unique ID of the property. |
| `URL` | `varchar2` | URL | [ ] |  | Address being accessed. |

## Chiavi

| Key | Column | Si riferisce a | 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. |


## Note di rilascio

Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver:

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