invantive documentation
Invantive Support ForumsLog In / Sign Up

SYSTEMSQLEXECUTIONS: Data Dictionary SQL Executions

read only

  • Catalog: DataDictionary
  • Schema: Invantive
  • Label: SQL Executions

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

Can only retrieve data.

Table Columns

The columns of the table SYSTEMSQLEXECUTIONS are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

Name Data Type Label Required Marks 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_TIME_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.

Keys

Key Column Refers to Kind Description
SYSTEMSQLEXECUTIONS_STATEMENT_ID_SYSTEMSQLAREA_fk STATEMENT_ID SYSTEMSQLAREA.ID Key

Referenced By

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: