---
title: "SYSTEMSQLEXECUTIONS (Data Dictionary)"
description: "SQL Executions"
language: fr
source_language: en
translation_state: pending
canonical: https://documentation.invantive.eu/fr/datamodels/datadictionary/DataDictionary.Invantive.SYSTEMSQLEXECUTIONS
original: https://documentation.invantive.eu/en/datamodels/datadictionary/DataDictionary.Invantive.SYSTEMSQLEXECUTIONS
updated: 2026-11-16T20:45:37Z
license: https://documentation.invantive.eu/fr/
---

# SYSTEMSQLEXECUTIONS: Data Dictionary SQL Executions

`read only`

- Catalogue : `DataDictionary`
- Schéma : `Invantive`
- Label: SQL Executions

All SQL statement executions, executed by Invantive's UniversalSQL engine.

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

## Colonnes de table

Les colonnes de la table `SYSTEMSQLEXECUTIONS` 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 |
|---|---|---|:---:|---|---|
| `BILLING_ID` | `varchar2` | ID de facturation | [ ] |  | ID for billing. |
| `DATA_CONTAINER_ID` | `varchar2(4000)` | ID du conteneur de données | [ ] |  | Data container ID. |
| `DURATION_MS` | `double` | Durée (ms) | [ ] |  | Duration (ms). |
| `DURATION_TICKS` | `int64` | Durée (ticks) | [ ] |  | Duration (ticks). |
| `END_TIME_UTC` | `datetime` | Heure de fin | [ ] |  | Time at which the SQL fetch was completed (UTC). |
| `GUI_IP_ADDRESS_EXTERNAL` | `varchar2(240)` | Adresse IP externe GUI | [ ] |  | External IP address of the GUI application. |
| `GUI_IP_PORT` | `uint16` | Port IP externe de la GUI | [ ] |  | External IP port of the GUI application. |
| `HEAP_BYTES_ALLOCATED` | `int64` | Nombre d'octets alloués dans le tas | [ ] |  | Number of bytes allocated on the managed heap by the execution: the sum over the outermost step of every statement of the batch, plus what the workers of a parallel clause allocated on their own threads.Counts bytes allocated rather than bytes retained, so it never decreases. |
| `ID` | `guid` | ID | [x] |  | Unique ID of the execution. |
| `INBOUND_CORRELATION_IDS` | `varchar2(240)` | Identifiants de corrélation entrants | [ ] |  | Inbound correlation IDs. |
| `IO_BYTES_RECEIVED` | `int64` | Octets reçus | [ ] |  | Number of bytes received using I/O. |
| `IO_BYTES_SENT` | `int64` | Octets envoyés | [ ] |  | Number of bytes sent using I/O. |
| `IO_DURATION_MS` | `double` | Durée des opérations d'E/S (ms) | [ ] |  | Duration of I/O (ms). |
| `IO_NUMBER_OF_PARTITIONS` | `int32` | Nombre de Partitions | [ ] |  | Number of partitions accessed through I/O. |
| `IO_ROW_COUNT` | `int64` | Nombre de lignes d'E/S | [ ] |  | Number of rows retrieved using I/O. |
| `MANAGED_THREAD_ID` | `int32` | ID du fil géré | [ ] |  | Managed thread ID. |
| `PARAMETER_VALUES` | `varchar2(4000)` | Valeurs de paramètre | [ ] |  | Parameter values. |
| `REQUEST_ID` | `varchar2(60)` | ID de demande | [ ] |  | Request ID. |
| `RESULT_SET_NAME` | `varchar2(4000)` | Nom de l'ensemble de résultats | [ ] |  | Name of result set. |
| `ROW_COUNT` | `int64` | Rows | [ ] |  | Number of rows retrieved. |
| `SQL_STATEMENT` | `varchar2` | Instruction SQL | [x] |  | SQL statement. |
| `START_TIME_UTC` | `datetime` | Heure de début | [ ] |  | Time at which the SQL fetch was started (UTC). |
| `STATEMENT_FINGER_PRINT` | `varchar2(240)` | Empreinte digitale | [x] |  | Unique finger print of the SQL statement. |
| `STATEMENT_ID` | `guid` | Référence de la déclaration | [x] |  | Unique ID of the SQL statement. |
| `TASK_ID` | `int32` | ID de Tâche | [ ] |  | Task ID. |
| `THREAD_CPU_TIME_NS` | `int64` | Temps CPU du thread (ns) | [ ] |  | CPU time in nanoseconds, kernel plus user, which the operating system charged to the threads of the execution, including the workers of a parallel clause.CPU time spent rather than wall clock, so a statement which put four workers to work can report more nanoseconds than it lasted. |

## Clés

| Key | Column | Se réfère à | Kind | Description |
|---|---|---|---|---|
| `SYSTEMSQLEXECUTIONS_STATEMENT_ID_SYSTEMSQLAREA_fk` | `STATEMENT_ID` | [SYSTEMSQLAREA](DataDictionary.Invantive.SYSTEMSQLAREA)`.ID` | Key |  |

## Référencée

- [SESSIONIOS](DataDictionary.Invantive.SESSIONIOS) `EXECUTION_ID` (Textual)
- [SYSTEMSQLEXECUTIONSLEEPS](DataDictionary.Invantive.SYSTEMSQLEXECUTIONSLEEPS) `EXECUTION_ID` (Key)
- [SYSTEMSQLEXECUTIONSTEPS](DataDictionary.Invantive.SYSTEMSQLEXECUTIONSTEPS) `EXECUTION_ID` (Key)


## 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)
