SYSTEMSQLAREA: Data Dictionary SQL Statements Executed
read only
- Catálogo:
DataDictionary - Esquema:
Invantive - Label: SQL Statements Executed
All SQL statements executed by Invantive's UniversalSQL engine.
Solo puede recuperar datos.
Columnas de la Tabla
A continuación se muestran las columnas de la tabla SYSTEMSQLAREA. 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 |
|---|---|---|---|---|---|
EXECUTIONS |
int32 |
Executions | Number of executions. | ||
FINGER_ |
varchar2 |
Huella digital | Unique finger print | ||
FIRST_ |
datetime |
Primera Hora de Finalización | Time at which the SQL was first executed (UTC). | ||
FIRST_ |
datetime |
Primera Hora de Inicio | Time at which the SQL was first executed (UTC). | ||
ID |
guid |
ID | Unique ID. | ||
LAST_ |
datetime |
Última hora de finalización | Time at which the SQL was last executed (UTC). | ||
LAST_ |
datetime |
Última hora de inicio | Time at which the SQL was last executed (UTC). | ||
MANAGED_ |
int32 |
ID de Hilo Administrado | Managed thread ID. | ||
NUMBER_ |
int32 |
Número de campos | Number of fields in the result set. | ||
NUMBER_ |
int32 |
Cantidad de subprocesos gestionados | Number of managed threads. | ||
NUMBER_ |
int32 |
Número de solicitudes | Number of requests. | ||
NUMBER_ |
int32 |
Cantidad de tareas | Number of tasks. | ||
PARAMETER_ |
varchar2 |
Valores del Parámetro | Parameter values. | ||
REQUEST_ |
varchar2 |
Solicitar ID | Request ID. | ||
ROW_ |
int64 |
Rows | Number of rows retrieved. | ||
SQL_ |
varchar2 |
Sentencia de SQL | SQL statement. | ||
TASK_ |
int32 |
ID de Tarea | Task ID. |
Referenciado por
- SESSIONIOS
STATEMENT_ID(Textual) - SYSTEMSQLEXECUTIONS
STATEMENT_ID(Key) - SYSTEMSQLEXECUTIONSLEEPS
STATEMENT_ID(Key) - SYSTEMSQLEXECUTIONSTEPS
STATEMENT_ID(Key)
Notas de la Versión
Cambios introducidos en cada versión en las tablas, columnas, atributos y capacidades del controlador: