invantive documentation
Invantive Support ForumsLog In / Sign Up

SYSTEMSQLEXECUTIONSLEEPS: Data Dictionary SQL Execution Sleeps

read only

  • Catalog: DataDictionary
  • Schema: Invantive
  • Label: SQL Execution Sleeps

Sleeps executed by Invantive's UniversalSQL engine during the execution of SQL statements.

Can only retrieve data.

Table Columns

The columns of the table SYSTEMSQLEXECUTIONSLEEPS 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
ACTUAL_DURATION_MS double Actual Duration (ms) Actual duration in milliseconds of the sleep.
END_TIME_UTC datetime End Time Time at which the sleep was completed (UTC).
EXECUTION_ID uuid SQL Execution ID ID of the SQL execution.
EXECUTION_STEP_ID int64 SQL Execution Step ID ID of the SQL execution step.
EXPECTED_DURATION_MS double Expected Duration (ms) Expected duration in milliseconds of the sleep.
ID int64 ID Unique ID of the sleep.
MESSAGE_CODE varchar2(30) Message Code Code of the message to indicate the origin.
PARTITION varchar2(30) Partition Specific partition on which the sleep was executed.
START_TIME_UTC datetime Start Time Time at which the sleep was started (UTC).
STATEMENT_ID uuid SQL Statement ID ID of the SQL statement.
TABLE_NAME varchar2 Table Name Name of the table.

Keys

Key Column Refers to Kind Description
SYSTEMSQLEXECUTIONSLEEPS_EXECUTION_ID_SYSTEMSQLEXECUTIONS_fk EXECUTION_ID SYSTEMSQLEXECUTIONS.ID Key
SYSTEMSQLEXECUTIONSLEEPS_EXECUTION_STEP_ID_SYSTEMSQLEXECUTIONSTEPS_fk EXECUTION_STEP_ID SYSTEMSQLEXECUTIONSTEPS.ID Key
SYSTEMSQLEXECUTIONSLEEPS_STATEMENT_ID_SYSTEMSQLAREA_fk STATEMENT_ID SYSTEMSQLAREA.ID Key

Release Notes

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