# 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` | `double` | CPU Duration (ms) | ☐ | Duration in milliseconds of CPU usage on this step. | | `DURATION_IO_MS` | `double` | I/O Duration (ms) | ☐ | Duration in milliseconds of the I/O on this step. | | `DURATION_MS` | `double` | Duration (ms) | ☐ | Duration in milliseconds of the step. | | `DURATION_SLEEP_MS` | `double` | 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 | | `HEAP_BYTES_ALLOCATED` | `int64` | Heap bytes allocated | ☐ | 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 | ☑ | 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` | `double` | Step Duration Clock (ms) | ☐ | Duration in milliseconds of the step (excluding children). | | `STEP_DURATION_CPU_MS` | `double` | Step CPU Duration (ms) | ☐ | Duration in milliseconds of CPU usage on this step (excluding children). | | `STEP_DURATION_IO_MS` | `double` | Step I/O Duration (ms) | ☐ | Duration in milliseconds of the I/O on this step (excluding children). | | `STEP_DURATION_SLEEP_MS` | `double` | Step Duration Sleeping (ms) | ☐ | Duration in milliseconds of the sleep on this step (excluding children). | | `TASK_ID` | `int32` | Task ID | ☐ | Task ID. | | `THREAD_CPU_NS` | `int64` | Thread CPU time (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` | | ☑ | 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 Text Add Count | | `TOTAL_SHARED_OBJECTS_STRING_ADD_LENGTH` | `int64` | | ☑ | Total Shared Objects Text Add Length | | `TOTAL_SHARED_OBJECTS_STRING_ALREADY_SHARED_COUNT` | `int64` | | ☑ | Total Shared Objects Text Already Shared Count | | `TOTAL_SHARED_OBJECTS_STRING_ALREADY_SHARED_LENGTH` | `int64` | | ☑ | Total Shared Objects Text Already Shared Length | | `TOTAL_SHARED_OBJECTS_STRING_REUSE_COUNT` | `int64` | | ☑ | Total Shared Objects Text Reuse Count | | `TOTAL_SHARED_OBJECTS_STRING_REUSE_LENGTH` | `int64` | | ☑ | Total Shared Objects Text Reuse Length |