# SYSTEMSQLEXECUTIONSTEPS: Data Dictionary SQL Execution Steps Individual processing steps executed by Invantive's UniversalSQL engine during the execution of SQL statements, their relationships and their statistics. - Catalog: `DataDictionary` - Schema: `Invantive` - Alias: `sep` - Label: SQL Execution Steps This is a read-only view. The Data Dictionary API may not support changing the data or the Invantive UniversalSQL driver for Data Dictionary does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Data Dictionary API. ## View Columns The columns of the view `SYSTEMSQLEXECUTIONSTEPS` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `ALIAS` | `varchar2`(240) | Alias | ☐ | Alias of the result set. | | `API_CALLS_ACTUAL` | `int64` | | ☑ | API Calls Actual | | `API_CALLS_FROM_DISK_CACHE` | `int64` | | ☑ | API Calls From Disk Cache | | `API_CALLS_FROM_MEMORY_CACHE` | `int64` | | ☑ | API Calls From Memory Cache | | `API_ROWS_ACTUAL` | `int64` | | ☑ | API Rows Actual | | `API_ROWS_FROM_DISK_CACHE` | `int64` | | ☑ | API Rows From Disk Cache | | `API_ROWS_FROM_MEMORY_CACHE` | `int64` | | ☑ | API Rows From Memory Cache | | `BYTES_IN` | `int64` | Bytes In | ☐ | Number of bytes input. | | `BYTES_OUT` | `int64` | Bytes Out | ☐ | Number of bytes output. | | `COLUMNS_IN` | `int32` | Columns In | ☐ | Number of columns input. | | `COLUMNS_OUT` | `int32` | Columns Out | ☐ | Number of columns output. | | `DEPTH` | `int32` | Depth | ☑ | Depth of the step. | | `DESCRIPTION` | `varchar2`(240) | Description | ☐ | Description of the step. | | `DURATION_CPU_MS` | `int64` | CPU Duration (ms) | ☐ | Duration in milliseconds of CPU usage on this step. | | `DURATION_IO_MS` | `int64` | I/O Duration (ms) | ☐ | Duration in milliseconds of the I/O on this step. | | `DURATION_MS` | `int64` | Duration (ms) | ☐ | Duration in milliseconds of the step. | | `DURATION_SLEEP_MS` | `int64` | Sleep Duration (ms) | ☐ | Duration in milliseconds of the sleep on this step. | | `DURATION_TICKS` | `int64` | Duration (Ticks) | ☐ | Duration in ticks of the step. | | `END_TIME_UTC` | `datetime` | End Time | ☐ | Time at which the SQL execution was ended (UTC). | | `EXECUTION_ID` | `guid` | Execution ID | ☑ | Unique ID of the SQL statement execution. | | `EXECUTION_OPTIONS_ID` | `guid` | Execution Options ID | ☐ | Execution options ID. | | `FINGER_PRINT` | `varchar2`(240) | Finger Print | ☑ | Unique finger print | | `ID` | `int64` | ID | ☑ | Unique ID of the step. | | `MANAGED_THREAD_ID` | `int32` | Managed Thread ID | ☐ | Managed thread ID. | | `PARAMETERS` | `varchar2`(1000) | Parameters | ☐ | Parameters of the step. | | `PARENT_ID` | `int64` | Parent ID | ☐ | ID of the parent step. | | `REQUEST_ID` | `varchar2`(60) | Request ID | ☐ | Request ID. | | `ROOT_ID` | `int64` | Root ID | ☑ | Unique ID of the step at the root of the tree. | | `ROWS_IN` | `int64` | Rows In | ☐ | Number of rows input. | | `ROWS_OUT` | `int64` | Rows Out | ☐ | Number of rows output. | | `SHARED_OBJECTS_BYTES_ADD_COUNT` | `int64` | | ☑ | Shared Objects Bytes Add Count | | `SHARED_OBJECTS_BYTES_ADD_LENGTH` | `int64` | | ☑ | Shared Objects Bytes Add Length | | `SHARED_OBJECTS_BYTES_ALREADY_SHARED_COUNT` | `int64` | | ☑ | Shared Objects Bytes Already Shared Count | | `SHARED_OBJECTS_BYTES_ALREADY_SHARED_LENGTH` | `int64` | | ☑ | Shared Objects Bytes Already Shared Length | | `SHARED_OBJECTS_BYTES_REUSE_COUNT` | `int64` | | ☑ | Shared Objects Bytes Reuse Count | | `SHARED_OBJECTS_BYTES_REUSE_LENGTH` | `int64` | | ☑ | Shared Objects Bytes Reuse Length | | `SHARED_OBJECTS_STRING_ADD_COUNT` | `int64` | | ☑ | Shared Objects Text Add Count | | `SHARED_OBJECTS_STRING_ADD_LENGTH` | `int64` | | ☑ | Shared Objects Text Add Length | | `SHARED_OBJECTS_STRING_ALREADY_SHARED_COUNT` | `int64` | | ☑ | Shared Objects Text Already Shared Count | | `SHARED_OBJECTS_STRING_ALREADY_SHARED_LENGTH` | `int64` | | ☑ | Shared Objects Text Already Shared Length | | `SHARED_OBJECTS_STRING_REUSE_COUNT` | `int64` | | ☑ | Shared Objects Text Reuse Count | | `SHARED_OBJECTS_STRING_REUSE_LENGTH` | `int64` | | ☑ | Shared Objects Text Reuse Length | | `START_TIME_UTC` | `datetime` | Start Time | ☐ | Time at which the SQL execution step was started (UTC). | | `STATEMENT_ID` | `guid` | Statement ID | ☑ | Unique ID of the SQL statement. | | `STEP_DURATION_CLOCK_MS` | `int64` | Step Duration Clock (ms) | ☐ | Duration in milliseconds of the step (excluding children). | | `STEP_DURATION_CPU_MS` | `int64` | Step CPU Duration (ms) | ☐ | Duration in milliseconds of CPU usage on this step (excluding children). | | `STEP_DURATION_IO_MS` | `int64` | Step I/O Duration (ms) | ☐ | Duration in milliseconds of the I/O on this step (excluding children). | | `STEP_DURATION_SLEEP_MS` | `int64` | Step Duration Sleeping (ms) | ☐ | Duration in milliseconds of the sleep on this step (excluding children). | | `TASK_ID` | `int32` | Task ID | ☐ | Task ID. | | `TOTAL_API_CALLS_ACTUAL` | `int64` | | ☑ | Total API Calls Actual | | `TOTAL_API_CALLS_FROM_DISK_CACHE` | `int64` | | ☑ | Total API Calls From Disk Cache | | `TOTAL_API_CALLS_FROM_MEMORY_CACHE` | `int64` | | ☑ | Total API Calls From Memory Cache | | `TOTAL_API_ROWS_ACTUAL` | `int64` | | ☑ | Total API Rows Actual | | `TOTAL_API_ROWS_FROM_DISK_CACHE` | `int64` | | ☑ | Total API Rows From Disk Cache | | `TOTAL_API_ROWS_FROM_MEMORY_CACHE` | `int64` | | ☑ | Total API Rows From Memory Cache | | `TOTAL_SHARED_OBJECTS_BYTES_ADD_COUNT` | `int64` | | ☑ | Total Shared Objects Bytes Add Count | | `TOTAL_SHARED_OBJECTS_BYTES_ADD_LENGTH` | `int64` | | ☑ | Total Shared Objects Bytes Add Length | | `TOTAL_SHARED_OBJECTS_BYTES_ALREADY_SHARED_COUNT` | `int64` | | ☑ | Total Shared Objects Bytes Already Shared Count | | `TOTAL_SHARED_OBJECTS_BYTES_ALREADY_SHARED_LENGTH` | `int64` | | ☑ | Total Shared Objects Bytes Already Shared Length | | `TOTAL_SHARED_OBJECTS_BYTES_REUSE_COUNT` | `int64` | | ☑ | Total Shared Objects Bytes Reuse Count | | `TOTAL_SHARED_OBJECTS_BYTES_REUSE_LENGTH` | `int64` | | ☑ | Total Shared Objects Bytes Reuse Length | | `TOTAL_SHARED_OBJECTS_STRING_ADD_COUNT` | `int64` | | ☑ | Total Shared Objects String Add Count | | `TOTAL_SHARED_OBJECTS_STRING_ADD_LENGTH` | `int64` | | ☑ | Total Shared Objects String Add Length | | `TOTAL_SHARED_OBJECTS_STRING_ALREADY_SHARED_COUNT` | `int64` | | ☑ | Total Shared Objects String Already Shared Count | | `TOTAL_SHARED_OBJECTS_STRING_ALREADY_SHARED_LENGTH` | `int64` | | ☑ | Total Shared Objects String Already Shared Length | | `TOTAL_SHARED_OBJECTS_STRING_REUSE_COUNT` | `int64` | | ☑ | Total Shared Objects String Reuse Count | | `TOTAL_SHARED_OBJECTS_STRING_REUSE_LENGTH` | `int64` | | ☑ | Total Shared Objects String Reuse Length |