invantive documentation
Foros de Soporte de InvantiveIniciar Sesión / Registrarse

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_ID varchar2 ID de Facturación ID for billing.
DATA_CONTAINER_ID varchar2(4000) ID del Contenedor de Datos Data container ID.
DURATION_MS double Duración (ms) Duration (ms).
DURATION_TICKS int64 Duración (garrapatas) Duration (ticks).
END_TIME_UTC datetime Hora de finalización Time at which the SQL fetch was completed (UTC).
GUI_IP_ADDRESS_EXTERNAL varchar2(240) GUI Dirección de IP Externa External IP address of the GUI application.
GUI_IP_PORT uint16 IP externa de la GUI y puerto External IP port of the GUI application.
HEAP_BYTES_ALLOCATED 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_CORRELATION_IDS varchar2(240) Identificadores de correlación entrantes Inbound correlation IDs.
IO_BYTES_RECEIVED int64 Bytes recibidos Number of bytes received using I/O.
IO_BYTES_SENT int64 Bytes enviados Number of bytes sent using I/O.
IO_DURATION_MS double Duración de E/S (ms) Duration of I/O (ms).
IO_NUMBER_OF_PARTITIONS int32 Número de particiones Number of partitions accessed through I/O.
IO_ROW_COUNT int64 Recuento de filas de E/S Number of rows retrieved using I/O.
MANAGED_THREAD_ID int32 ID de Hilo Administrado Managed thread ID.
PARAMETER_VALUES varchar2(4000) Valores del Parámetro Parameter values.
REQUEST_ID varchar2(60) Solicitar ID Request ID.
RESULT_SET_NAME varchar2(4000) Nombre del conjunto de resultados Name of result set.
ROW_COUNT int64 Rows Number of rows retrieved.
SQL_STATEMENT varchar2 Sentencia de SQL SQL statement.
START_TIME_UTC datetime Hora de Inicio Time at which the SQL fetch was started (UTC).
STATEMENT_FINGER_PRINT varchar2(240) Huella digital Unique finger print of the SQL statement.
STATEMENT_ID guid ID de estado de cuenta Unique ID of the SQL statement.
TASK_ID int32 ID de Tarea Task ID.
THREAD_CPU_TIME_NS 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_ID_SYSTEMSQLAREA_fk STATEMENT_ID SYSTEMSQLAREA.ID Key

Referenciado por

Notas de la Versión

Cambios introducidos en cada versión en las tablas, columnas, atributos y capacidades del controlador: