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_ |
double |
Actual Duration (ms) | Actual duration in milliseconds of the sleep. | ||
END_ |
datetime |
End Time | Time at which the sleep was completed (UTC). | ||
EXECUTION_ |
uuid |
SQL Execution ID | ID of the SQL execution. | ||
EXECUTION_ |
int64 |
SQL Execution Step ID | ID of the SQL execution step. | ||
EXPECTED_ |
double |
Expected Duration (ms) | Expected duration in milliseconds of the sleep. | ||
ID |
int64 |
ID | Unique ID of the sleep. | ||
MESSAGE_ |
varchar2 |
Message Code | Code of the message to indicate the origin. | ||
PARTITION |
varchar2 |
Partition | Specific partition on which the sleep was executed. | ||
START_ |
datetime |
Start Time | Time at which the sleep was started (UTC). | ||
STATEMENT_ |
uuid |
SQL Statement ID | ID of the SQL statement. | ||
TABLE_ |
varchar2 |
Table Name | Name of the table. |
Keys
| Key | Column | Refers to | Kind | Description |
|---|---|---|---|---|
SYSTEMSQLEXECUTIONSLEEPS_ |
EXECUTION_ |
SYSTEMSQLEXECUTIONS.ID |
Key | |
SYSTEMSQLEXECUTIONSLEEPS_ |
EXECUTION_ |
SYSTEMSQLEXECUTIONSTEPS.ID |
Key | |
SYSTEMSQLEXECUTIONSLEEPS_ |
STATEMENT_ |
SYSTEMSQLAREA.ID |
Key |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: