SYSTEMSQLEXECUTIONSLEEPS: Data Dictionary SQL Execution Sleeps
read only
- Catálogo:
DataDictionary - Esquema:
Invantive - Label: SQL Execution Sleeps
Sleeps executed by Invantive's UniversalSQL engine during the execution of SQL statements.
Solo puede recuperar datos.
Columnas de la Tabla
A continuación se muestran las columnas de la tabla SYSTEMSQLEXECUTIONSLEEPS. Cada columna tiene un tipo de datos SQL. Se debe proporcionar un nuevo valor no nulo para cada columna requerida en todo momento durante la inserción y la actualización.
| Name | Tipo de Datos | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
ACTUAL_ |
double |
Duración real (ms) | Actual duration in milliseconds of the sleep. | ||
END_ |
datetime |
Hora de finalización | Time at which the sleep was completed (UTC). | ||
EXECUTION_ |
uuid |
ID de ejecución de SQL | ID of the SQL execution. | ||
EXECUTION_ |
int64 |
ID del paso de ejecución de SQL | ID of the SQL execution step. | ||
EXPECTED_ |
double |
Duración esperada (ms) | Expected duration in milliseconds of the sleep. | ||
ID |
int64 |
ID | Unique ID of the sleep. | ||
MESSAGE_ |
varchar2 |
Código del Mensaje | Code of the message to indicate the origin. | ||
PARTITION |
varchar2 |
Partition | Specific partition on which the sleep was executed. | ||
START_ |
datetime |
Hora de Inicio | Time at which the sleep was started (UTC). | ||
STATEMENT_ |
uuid |
ID de sentencia SQL | ID of the SQL statement. | ||
TABLE_ |
varchar2 |
Nombre de la Tabla | Name of the table. |
Teclas
| Key | Column | Se refiere a | Kind | Description |
|---|---|---|---|---|
SYSTEMSQLEXECUTIONSLEEPS_ |
EXECUTION_ |
SYSTEMSQLEXECUTIONS.ID |
Key | |
SYSTEMSQLEXECUTIONSLEEPS_ |
EXECUTION_ |
SYSTEMSQLEXECUTIONSTEPS.ID |
Key | |
SYSTEMSQLEXECUTIONSLEEPS_ |
STATEMENT_ |
SYSTEMSQLAREA.ID |
Key |
Notas de la Versión
Cambios introducidos en cada versión en las tablas, columnas, atributos y capacidades del controlador: