---
title: "SYSTEMSQLEXECUTIONSTEPS (Data Dictionary)"
description: "SQL Execution Steps"
language: it
source_language: en
translation_state: pending
canonical: https://documentation.invantive.eu/it/datamodels/datadictionary/DataDictionary.Invantive.SYSTEMSQLEXECUTIONSTEPS
original: https://documentation.invantive.eu/en/datamodels/datadictionary/DataDictionary.Invantive.SYSTEMSQLEXECUTIONSTEPS
updated: 2026-11-16T20:45:40Z
license: https://documentation.invantive.eu/it/
---

# SYSTEMSQLEXECUTIONSTEPS: Data Dictionary SQL Execution Steps

`read only`

- Catalogo: `DataDictionary`
- Schema: `Invantive`
- Label: SQL Execution Steps

Individual processing steps executed by Invantive's UniversalSQL engine during the execution of SQL statements, their relationships and their statistics.

È possibile solo recuperare i dati.

## Colonne della tabella

Di seguito sono riportate le colonne della tabella `SYSTEMSQLEXECUTIONSTEPS`. 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 |
|---|---|---|:---:|---|---|
| `ALGORITHM` | `varchar2(240)` | Algorithm | [ ] |  | How the step went about its work where it had a choice: what a join chose, such as an index join on columns or a nested loop, and for a nested loop why no index was taken.Empty where the step had no choice. |
| `ALIAS` | `varchar2(240)` | Alias | [ ] |  | Alias of the result set. |
| `API_CALLS_ACTUAL` | `int64` | Chiamate API effettive | [x] |  | Chiamate API effettive |
| `API_CALLS_FROM_DISK_CACHE` | `int64` | Chiamate API dalla memoria cache su disco | [x] |  | API Calls From Disk Cache |
| `API_CALLS_FROM_MEMORY_CACHE` | `int64` | Chiamate API dalla memoria cache | [x] |  | API Calls From Memory Cache |
| `API_ROWS_ACTUAL` | `int64` | Righe API effettive | [x] |  | Righe API effettive |
| `API_ROWS_FROM_DISK_CACHE` | `int64` | Righe API dalla memoria cache su disco | [x] |  | API Rows From Disk Cache |
| `API_ROWS_FROM_MEMORY_CACHE` | `int64` | Righe API dalla memoria cache | [x] |  | API Rows From Memory Cache |
| `BYTES_IN` | `int64` | Byte in ingresso | [ ] |  | Number of bytes input. |
| `BYTES_OUT` | `int64` | Byte in uscita | [ ] |  | Number of bytes output. |
| `COLUMNS_IN` | `int32` | Colonne in | [ ] |  | Number of columns input. |
| `COLUMNS_OUT` | `int32` | Colonne in uscita | [ ] |  | Number of columns output. |
| `COUNTERS` | `varchar2(4000)` | Counters | [ ] |  | What the step itself did, counted, as a JSON object of the counts which are not zero, such as {"PlanBuilds":1,"PairsEvaluated":12}: plans built, expressions found in or added to the expression cache, the algorithm a join chose, pairs a join evaluated, rows sorted.The counts of a statement are the sum over its steps.Empty when the step counted nothing. |
| `DEPTH` | `int32` | Depth | [x] |  | Depth of the step. |
| `DESCRIPTION` | `varchar2(240)` | Description | [ ] |  | Description of the step. |
| `DURATION_CPU_MS` | `double` | Durata dell'elaborazione della CPU (ms) | [ ] |  | Duration in milliseconds of CPU usage on this step. |
| `DURATION_IO_MS` | `double` | Durata I/O (ms) | [ ] |  | Duration in milliseconds of the I/O on this step. |
| `DURATION_MS` | `double` | Durata (ms) | [ ] |  | Duration in milliseconds of the step. |
| `DURATION_SLEEP_MS` | `double` | Durata del sonno (ms) | [ ] |  | Duration in milliseconds of the sleep on this step. |
| `DURATION_TICKS` | `int64` | Durata (segni di spunta) | [ ] |  | Duration in ticks of the step. |
| `END_TIME_UTC` | `datetime` | Ora di fine | [ ] |  | Time at which the SQL execution was ended (UTC). |
| `ESTIMATED_ROWS` | `int64` | Numero stimato di righe | [ ] |  | Rows of the table read by the step as its data container declares them, before any filter; compare with ROWS_OUT.Empty where nothing is declared. |
| `EXECUTION_ID` | `guid` | ID di esecuzione | [x] |  | Unique ID of the SQL statement execution. |
| `EXECUTION_OPTIONS_ID` | `guid` | ID delle opzioni di esecuzione | [ ] |  | Execution options ID. |
| `FINGER_PRINT` | `varchar2(240)` | Impronta digitale | [x] |  | Unique finger print |
| `GC_COLLECTIONS_GENERATION_0` | `int32` | Raccolta dei rifiuti di generazione 0 in corso | [ ] |  | Number of garbage collections of generation 0 in the whole process while the step ran, not counting those of generation 1 and 2.The process runs other statements and work of its own at the same time, so the collections were not necessarily caused by the step, and a step and its children count the same collections.Empty while the step runs. |
| `GC_COLLECTIONS_GENERATION_1` | `int32` | Raccolta dei rifiuti di generazione 1 in corso | [ ] |  | Number of garbage collections of generation 1 in the whole process while the step ran, not counting those of generation 2.The process runs other statements and work of its own at the same time, so the collections were not necessarily caused by the step, and a step and its children count the same collections.Empty while the step runs. |
| `GC_COLLECTIONS_GENERATION_2` | `int32` | Raccolta dei rifiuti di generazione 2 in corso | [ ] |  | Number of full garbage collections, of generation 2, in the whole process while the step ran.The process runs other statements and work of its own at the same time, so the collections were not necessarily caused by the step, and a step and its children count the same collections.Empty while the step runs. |
| `GC_PAUSE_MS` | `double` | Pausa della raccolta dei rifiuti nel processo (ms) | [ ] |  | Milliseconds in which the garbage collector paused the whole process while the step ran.A pause stops every statement running at that moment, so it is not time lost by the step alone, and a step and its children count the same pauses.Empty while the step runs and on .NET Framework, which does not measure it. |
| `HEAP_BYTES_ALLOCATED` | `int64` | Byte allocati nell'heap | [ ] |  | Number of bytes allocated on the managed heap by the thread of the step, from its start until its end.Counts bytes allocated rather than bytes retained, so it never decreases; a step and its children on one thread both count the same bytes, as they both count the same milliseconds.Empty when the step ended on another thread than the one which started it. |
| `ID` | `int64` | ID | [x] |  | Unique ID of the step. |
| `KIND` | `varchar2(30)` | Tipo di passo | [ ] |  | What the step does, such as DataContainerRead, Join, Filter or Sort; empty where the code which made the step did not state it. |
| `MANAGED_THREAD_ID` | `int32` | ID thread gestito | [ ] |  | Managed thread ID. |
| `PARAMETERS` | `varchar2(1000)` | Parameters | [ ] |  | Parameters of the step. |
| `PARENT_ID` | `int64` | ID genitore | [ ] |  | ID of the parent step. |
| `REQUEST_ID` | `varchar2(60)` | ID richiesta | [ ] |  | Request ID. |
| `ROOT_ID` | `int64` | ID radice | [x] |  | Unique ID of the step at the root of the tree. |
| `ROWS_IN` | `int64` | Righe in | [ ] |  | Number of rows input. |
| `ROWS_OUT` | `int64` | Righe fuori | [ ] |  | Number of rows output. |
| `SHARED_OBJECTS_BYTES_ADD_COUNT` | `int64` | Conteggio dei byte aggiunti agli oggetti condivisi | [x] |  | Conteggio dei byte aggiunti agli oggetti condivisi |
| `SHARED_OBJECTS_BYTES_ADD_LENGTH` | `int64` | Oggetti condivisi - Byte - Aggiungi lunghezza | [x] |  | Oggetti condivisi - Byte - Aggiungi lunghezza |
| `SHARED_OBJECTS_BYTES_ALREADY_SHARED_COUNT` | `int64` | Oggetti condivisi - Byte già condivisi - Numero | [x] |  | Oggetti condivisi - Byte già condivisi - Numero |
| `SHARED_OBJECTS_BYTES_ALREADY_SHARED_LENGTH` | `int64` | Oggetti condivisi Byte già condivisi Lunghezza | [x] |  | Oggetti condivisi Byte già condivisi Lunghezza |
| `SHARED_OBJECTS_BYTES_REUSE_COUNT` | `int64` | Oggetti condivisi - Byte - Conteggio riutilizzi | [x] |  | Oggetti condivisi - Byte - Conteggio riutilizzi |
| `SHARED_OBJECTS_BYTES_REUSE_LENGTH` | `int64` | Oggetti condivisi - Byte - Riutilizzo - Lunghezza | [x] |  | Oggetti condivisi - Byte - Riutilizzo - Lunghezza |
| `SHARED_OBJECTS_STRING_ADD_COUNT` | `int64` | Conteggio delle aggiunte alle stringhe degli oggetti condivisi | [x] |  | Shared Objects Text Add Count |
| `SHARED_OBJECTS_STRING_ADD_LENGTH` | `int64` | Oggetti condivisi: aggiungi lunghezza alla stringa | [x] |  | Shared Objects Text Add Length |
| `SHARED_OBJECTS_STRING_ALREADY_SHARED_COUNT` | `int64` | Oggetti condivisi Stringa Già condivisa Conteggio | [x] |  | Shared Objects Text Already Shared Count |
| `SHARED_OBJECTS_STRING_ALREADY_SHARED_LENGTH` | `int64` | Oggetti condivisi Stringa Già condivisa Lunghezza | [x] |  | Shared Objects Text Already Shared Length |
| `SHARED_OBJECTS_STRING_REUSE_COUNT` | `int64` | Conteggio dei riutilizzi delle stringhe negli oggetti condivisi | [x] |  | Shared Objects Text Reuse Count |
| `SHARED_OBJECTS_STRING_REUSE_LENGTH` | `int64` | Lunghezza di riutilizzo delle stringhe negli oggetti condivisi | [x] |  | Shared Objects Text Reuse Length |
| `START_TIME_UTC` | `datetime` | Ora di inizio | [ ] |  | Time at which the SQL execution step was started (UTC). |
| `STATEMENT_ID` | `guid` | ID dichiarazione | [x] |  | Unique ID of the SQL statement. |
| `STEP_DURATION_CLOCK_MS` | `double` | Orologio della durata del passo (ms) | [ ] |  | Duration in milliseconds of the step (excluding children). |
| `STEP_DURATION_CPU_MS` | `double` | Passo Durata CPU (ms) | [ ] |  | Duration in milliseconds of CPU usage on this step (excluding children). |
| `STEP_DURATION_IO_MS` | `double` | Durata dell'I/O di passo (ms) | [ ] |  | Duration in milliseconds of the I/O on this step (excluding children). |
| `STEP_DURATION_SLEEP_MS` | `double` | Durata del passo Sonno (ms) | [ ] |  | Duration in milliseconds of the sleep on this step (excluding children). |
| `TASK_ID` | `int32` | ID compito | [ ] |  | Task ID. |
| `THREAD_CPU_TIME_NS` | `int64` | Tempo di CPU del thread (ns) | [ ] |  | CPU time in nanoseconds, kernel plus user, which the operating system charged to the thread of the step while it ran.A measurement, where DURATION_CPU_MS beside it is the wall clock minus the measured I/O and sleep and therefore also absorbs every wait nobody measured.A step and its children on one thread both count the same time.Empty when the step ended on another thread than the one which started it, or on a platform without a cheap per-thread clock.The resolution of the figure is the resolution of the per-thread clock of the platform, which is coarser than a nanosecond on some of them; a step short enough may therefore report zero rather than a small number. |
| `TOTAL_API_CALLS_ACTUAL` | `int64` | Totale chiamate API effettive | [x] |  | Totale chiamate API effettive |
| `TOTAL_API_CALLS_FROM_DISK_CACHE` | `int64` | Totale delle chiamate API dalla memoria cache su disco | [x] |  | Total API Calls From Disk Cache |
| `TOTAL_API_CALLS_FROM_MEMORY_CACHE` | `int64` | Totale delle chiamate API dalla memoria cache | [x] |  | Total API Calls From Memory Cache |
| `TOTAL_API_ROWS_ACTUAL` | `int64` | Totale righe API effettive | [x] |  | Totale righe API effettive |
| `TOTAL_API_ROWS_FROM_DISK_CACHE` | `int64` | Numero totale di righe API dalla memoria cache su disco | [x] |  | Total API Rows From Disk Cache |
| `TOTAL_API_ROWS_FROM_MEMORY_CACHE` | `int64` | Numero totale di righe API dalla memoria cache | [x] |  | Total API Rows From Memory Cache |
| `TOTAL_SHARED_OBJECTS_BYTES_ADD_COUNT` | `int64` | Totale oggetti condivisi (in byte) - Numero di aggiunte | [x] |  | Totale oggetti condivisi (in byte) - Numero di aggiunte |
| `TOTAL_SHARED_OBJECTS_BYTES_ADD_LENGTH` | `int64` | Totale oggetti condivisi in byte - Lunghezza aggiunta | [x] |  | Totale oggetti condivisi in byte - Lunghezza aggiunta |
| `TOTAL_SHARED_OBJECTS_BYTES_ALREADY_SHARED_COUNT` | `int64` | Totale oggetti condivisi (in byte) già condivisi: numero | [x] |  | Totale oggetti condivisi (in byte) già condivisi: numero |
| `TOTAL_SHARED_OBJECTS_BYTES_ALREADY_SHARED_LENGTH` | `int64` | Totale oggetti condivisi Byte già condivisi Lunghezza | [x] |  | Totale oggetti condivisi Byte già condivisi Lunghezza |
| `TOTAL_SHARED_OBJECTS_BYTES_REUSE_COUNT` | `int64` | Totale oggetti condivisi - Byte - Numero di riutilizzi | [x] |  | Totale oggetti condivisi - Byte - Numero di riutilizzi |
| `TOTAL_SHARED_OBJECTS_BYTES_REUSE_LENGTH` | `int64` | Totale Oggetti condivisi Byte Lunghezza di riutilizzo | [x] |  | Totale Oggetti condivisi Byte Lunghezza di riutilizzo |
| `TOTAL_SHARED_OBJECTS_STRING_ADD_COUNT` | `int64` | Conteggio totale delle stringhe aggiunte negli oggetti condivisi | [x] |  | Total Shared Objects Text Add Count |
| `TOTAL_SHARED_OBJECTS_STRING_ADD_LENGTH` | `int64` | Lunghezza totale delle stringhe degli oggetti condivisi | [x] |  | Total Shared Objects Text Add Length |
| `TOTAL_SHARED_OBJECTS_STRING_ALREADY_SHARED_COUNT` | `int64` | Totale oggetti condivisi String Numero già condiviso | [x] |  | Total Shared Objects Text Already Shared Count |
| `TOTAL_SHARED_OBJECTS_STRING_ALREADY_SHARED_LENGTH` | `int64` | Totale Oggetti condivisi Stringa Già condivisa Lunghezza | [x] |  | Total Shared Objects Text Already Shared Length |
| `TOTAL_SHARED_OBJECTS_STRING_REUSE_COUNT` | `int64` | Conteggio totale del riutilizzo delle stringhe negli oggetti condivisi | [x] |  | Total Shared Objects Text Reuse Count |
| `TOTAL_SHARED_OBJECTS_STRING_REUSE_LENGTH` | `int64` | Lunghezza totale delle stringhe riutilizzate negli oggetti condivisi | [x] |  | Total Shared Objects Text Reuse Length |

## Chiavi

| Key | Column | Si riferisce a | Kind | Description |
|---|---|---|---|---|
| `SYSTEMSQLEXECUTIONSTEPS_EXECUTION_ID_SYSTEMSQLEXECUTIONS_fk` | `EXECUTION_ID` | [SYSTEMSQLEXECUTIONS](DataDictionary.Invantive.SYSTEMSQLEXECUTIONS)`.ID` | Key |  |
| `SYSTEMSQLEXECUTIONSTEPS_PARENT_ID_SYSTEMSQLEXECUTIONSTEPS_fk` | `PARENT_ID` | [SYSTEMSQLEXECUTIONSTEPS](DataDictionary.Invantive.SYSTEMSQLEXECUTIONSTEPS)`.ID` | Key |  |
| `SYSTEMSQLEXECUTIONSTEPS_ROOT_ID_SYSTEMSQLEXECUTIONSTEPS_fk` | `ROOT_ID` | [SYSTEMSQLEXECUTIONSTEPS](DataDictionary.Invantive.SYSTEMSQLEXECUTIONSTEPS)`.ID` | Key |  |
| `SYSTEMSQLEXECUTIONSTEPS_STATEMENT_ID_SYSTEMSQLAREA_fk` | `STATEMENT_ID` | [SYSTEMSQLAREA](DataDictionary.Invantive.SYSTEMSQLAREA)`.ID` | Key |  |

## Riferito da

- [SESSIONIOS](DataDictionary.Invantive.SESSIONIOS) `EXECUTION_STEP_ID` (Textual)
- [SYSTEMSQLEXECUTIONSLEEPS](DataDictionary.Invantive.SYSTEMSQLEXECUTIONSLEEPS) `EXECUTION_STEP_ID` (Key)
- [SYSTEMSQLEXECUTIONSTEPS](DataDictionary.Invantive.SYSTEMSQLEXECUTIONSTEPS) `PARENT_ID` (Key)
- [SYSTEMSQLEXECUTIONSTEPS](DataDictionary.Invantive.SYSTEMSQLEXECUTIONSTEPS) `ROOT_ID` (Key)


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