# SYSTEMSQLEXECUTIONS: Data Dictionary SQL Executions All SQL statement executions, executed by Invantive's UniversalSQL engine. - Catalog: `DataDictionary` - Schema: `Invantive` - Alias: `saa` - Label: SQL Executions 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 `SYSTEMSQLEXECUTIONS` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `BILLING_ID` | `varchar2` | Billing ID | ☐ | ID for billing. | | `DATA_CONTAINER_ID` | `varchar2(4000)` | Data Container ID | ☐ | Data container ID. | | `DURATION_MS` | `double` | Duration (ms) | ☐ | Duration (ms). | | `DURATION_TICKS` | `int64` | Duration (Ticks) | ☐ | Duration (ticks). | | `END_TIME_UTC` | `datetime` | End Time | ☐ | Time at which the SQL fetch was completed (UTC). | | `GUI_IP_ADDRESS_EXTERNAL` | `varchar2(240)` | GUI External IP Address | ☐ | External IP address of the GUI application. | | `GUI_IP_PORT` | `uint16` | GUI External IP Port | ☐ | External IP port of the GUI application. | | `HEAP_BYTES_ALLOCATED` | `int64` | Heap bytes allocated | ☐ | 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 | ☑ | Unique ID of the execution. | | `INBOUND_CORRELATION_IDS` | `varchar2(240)` | Inbound Correlation IDs | ☐ | Inbound correlation IDs. | | `IO_BYTES_RECEIVED` | `int64` | Bytes Received | ☐ | Number of bytes received using I/O. | | `IO_BYTES_SENT` | `int64` | Bytes Sent | ☐ | Number of bytes sent using I/O. | | `IO_DURATION_MS` | `double` | I/O Duration (ms) | ☐ | Duration of I/O (ms). | | `IO_NUMBER_OF_PARTITIONS` | `int32` | Number of Partitions | ☐ | Number of partitions accessed through I/O. | | `IO_ROW_COUNT` | `int64` | I/O Row Count | ☐ | Number of rows retrieved using I/O. | | `MANAGED_THREAD_ID` | `int32` | Managed Thread ID | ☐ | Managed thread ID. | | `PARAMETER_VALUES` | `varchar2(4000)` | Parameter Values | ☐ | Parameter values. | | `REQUEST_ID` | `varchar2(60)` | Request ID | ☐ | Request ID. | | `RESULT_SET_NAME` | `varchar2(4000)` | Result Set Name | ☐ | Name of result set. | | `ROW_COUNT` | `int64` | Rows | ☐ | Number of rows retrieved. | | `SQL_STATEMENT` | `varchar2` | SQL Statement | ☑ | SQL statement. | | `START_TIME_UTC` | `datetime` | Start Time | ☐ | Time at which the SQL fetch was started (UTC). | | `STATEMENT_FINGER_PRINT` | `varchar2(240)` | Finger Print | ☑ | Unique finger print of the SQL statement. | | `STATEMENT_ID` | `guid` | Statement ID | ☑ | Unique ID of the SQL statement. | | `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 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. |