SYSTEMSQLEXECUTIONS: Data Dictionary SQL Executions
read only
- Catálogo:
DataDictionary - Esquema:
Invantive - Label: SQL Executions
All SQL statement executions, executed by Invantive's UniversalSQL engine.
Solo puede recuperar datos.
Columnas de la Tabla
A continuación se muestran las columnas de la tabla SYSTEMSQLEXECUTIONS. 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 |
|---|---|---|---|---|---|
BILLING_ |
varchar2 |
ID de Facturación | ID for billing. | ||
DATA_ |
varchar2 |
ID del Contenedor de Datos | Data container ID. | ||
DURATION_ |
double |
Duración (ms) | Duration (ms). | ||
DURATION_ |
int64 |
Duración (garrapatas) | Duration (ticks). | ||
END_ |
datetime |
Hora de finalización | Time at which the SQL fetch was completed (UTC). | ||
GUI_ |
varchar2 |
GUI Dirección de IP Externa | External IP address of the GUI application. | ||
GUI_ |
uint16 |
IP externa de la GUI y puerto | External IP port of the GUI application. | ||
HEAP_ |
int64 |
Bytes asignados en el montón | 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_ |
varchar2 |
Identificadores de correlación entrantes | Inbound correlation IDs. | ||
IO_ |
int64 |
Bytes recibidos | Number of bytes received using I/O. | ||
IO_ |
int64 |
Bytes enviados | Number of bytes sent using I/O. | ||
IO_ |
double |
Duración de E/S (ms) | Duration of I/O (ms). | ||
IO_ |
int32 |
Número de particiones | Number of partitions accessed through I/O. | ||
IO_ |
int64 |
Recuento de filas de E/S | Number of rows retrieved using I/O. | ||
MANAGED_ |
int32 |
ID de Hilo Administrado | Managed thread ID. | ||
PARAMETER_ |
varchar2 |
Valores del Parámetro | Parameter values. | ||
REQUEST_ |
varchar2 |
Solicitar ID | Request ID. | ||
RESULT_ |
varchar2 |
Nombre del conjunto de resultados | Name of result set. | ||
ROW_ |
int64 |
Rows | Number of rows retrieved. | ||
SQL_ |
varchar2 |
Sentencia de SQL | SQL statement. | ||
START_ |
datetime |
Hora de Inicio | Time at which the SQL fetch was started (UTC). | ||
STATEMENT_ |
varchar2 |
Huella digital | Unique finger print of the SQL statement. | ||
STATEMENT_ |
guid |
ID de estado de cuenta | Unique ID of the SQL statement. | ||
TASK_ |
int32 |
ID de Tarea | Task ID. | ||
THREAD_ |
int64 |
Tiempo de CPU del hilo (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. |
Teclas
| Key | Column | Se refiere a | Kind | Description |
|---|---|---|---|---|
SYSTEMSQLEXECUTIONS_ |
STATEMENT_ |
SYSTEMSQLAREA.ID |
Key |
Referenciado por
- SESSIONIOS
EXECUTION_ID(Textual) - SYSTEMSQLEXECUTIONSLEEPS
EXECUTION_ID(Key) - SYSTEMSQLEXECUTIONSTEPS
EXECUTION_ID(Key)
Notas de la Versión
Cambios introducidos en cada versión en las tablas, columnas, atributos y capacidades del controlador: