SESSIONIOS: Data Dictionary Session I/Os
read only
- Catálogo:
DataDictionary - Esquema:
Invantive - Label: Session I/Os
Individual I/Os executed by Invantive's UniversalSQL engine on the data containers during the execution of SQL statements and their statistics.
Solo puede recuperar datos.
Columnas de la Tabla
A continuación se muestran las columnas de la tabla SESSIONIOS. 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 |
|---|---|---|---|---|---|
ACTION |
varchar2 |
Action | Action, being either 'READ' or 'WRITE'. | ||
BILLING_ |
varchar2 |
ID de Facturación | ID for billing. | ||
BILLING_ |
varchar2 |
ID de identidad del grupo de facturación | Pool identity ID for billing. | ||
BILLING_ |
varchar2 |
Referencia de Facturación | Reference for billing, such as your cost centers. | ||
BYTES_ |
int64 |
Bytes recibidos | Number of bytes received. | ||
BYTES_ |
int64 |
Bytes enviados | Number of bytes sent. | ||
CACHE_ |
varchar2 |
ID de caché | Cache ID. | ||
CALL_ |
varchar2 |
Llamar un Nombre Seguro | Call safe name of the object. | ||
CLIENT_ |
varchar2 |
ID de Cliente | Client ID. | ||
DATA_ |
varchar2 |
Alias del Contenedor de Datos | Alias of the data container. | ||
DATA_ |
varchar2 |
ID del Contenedor de Datos | ID of the data container. | ||
DURATION_ |
double |
Duración de la CPU | CPU duration in milliseconds of the I/O. | ||
DURATION_ |
double |
Duración de E/S | I/O duration in milliseconds of the I/O. | ||
DURATION_ |
double |
Duration | Duration in milliseconds of the I/O. | ||
DURATION_ |
double |
Duración del sueño | Sleep duration in milliseconds of the I/O. | ||
ERROR_ |
varchar2 |
Mensaje de Error | Error message that occurred during executing the I/O. | ||
ERROR_ |
varchar2 |
Código del Mensaje de Error | Error message code that occurred during executing the I/O. | ||
EXECUTION_ |
datetime |
Fecha de finalización de la ejecución | Date at which the I/O was ended (UTC). | ||
EXECUTION_ |
guid |
ID de ejecución | ID of the SQL execution. | ||
EXECUTION_ |
datetime |
Fecha de inicio de la ejecución | Date at which the I/O was started (UTC). | ||
EXECUTION_ |
int64 |
ID del paso de ejecución de SQL | ID of the SQL execution step. | ||
FORWARDED_ |
char |
Reenviado a Customer Service | Indicator whether session I/O was forwarded. | ||
FROM_ |
char |
Desde la Caché de Aplicaciones | Indicator whether the data was retrieved from application-specific cache. | ||
FROM_ |
char |
De la caché | Indicator whether the data was retrieved from any cache. | ||
FROM_ |
char |
Desde la Caché del Disco | Indicator whether the data was retrieved from disk cache. | ||
FROM_ |
char |
Desde la Memoria Caché | Indicator whether the data was retrieved from memory cache. | ||
GUI_ |
varchar2 |
Acción GUI | Action performed within the user interface. | ||
GUI_ |
varchar2 |
Nombre del Módulo GUI | Module within the GUI application currently running. | ||
GUI_ |
varchar2 |
Versión del Módulo GUI | Version of module within the GUI application currently running. | ||
ID |
int64 |
ID | Unique ID of the property. | ||
IIID |
varchar2 |
IIID | Invantive installation ID. | ||
IUID |
varchar2 |
IUID | Invantive user ID. | ||
LICENSE_ |
varchar2 |
Código del Contrato de Licencia | License contract code. | ||
LICENSE_ |
varchar2 |
Identificador de la Clave de Licencia | License key identifier. | ||
MANAGED_ |
int32 |
ID de Hilo Administrado | Managed thread ID. | ||
ORIGIN |
varchar2 |
Origin | Why the I/O was made: 'User' for a question asked, 'Metadata' for finding out what the platform holds, and 'Preemptive' for data fetched ahead of a question expected shortly. | ||
PARAMETER_ |
varchar2 |
Lista de Parámetros | Parameters. | ||
PARTITION |
varchar2 |
Partition | Specific partition on which the I/O was executed. | ||
POOL_ |
varchar2 |
Identidad del Grupo | Pool identity. | ||
PROCESS_ |
uint32 |
ID de proceso | Process ID. | ||
PROVIDER_ |
guid |
UID de instancia de proveedor | Unique ID of the provider instance. | ||
PROVIDER_ |
varchar2 |
Provider | Name of provider. | ||
PUBLIC_ |
varchar2 |
Parámetros de Consulta Pública | Parameters added to the platform query. | ||
RECURSION_ |
int32 |
Nivel de Recursión | Recursion level. | ||
REMOTE_ |
varchar2 |
Identificadores de correlación remotos | Remote correlation IDs as a comma-separated list of key, colon, space and value. | ||
REQUEST_ |
varchar2 |
Solicitar ID | Request ID. | ||
ROUND_ |
int32 |
Viajes de ida y vuelta | Number of round trips. | ||
ROW_ |
int64 |
Rows | Number of rows exchanged. | ||
SESSION_ |
varchar2 |
Sesión-ID | ID of the session. | ||
STATEMENT_ |
guid |
ID de sentencia SQL | ID of the SQL statement. | ||
SUCCESSFUL |
char |
Succesful | Indicator whether the I/O completed successfully. | ||
TASK_ |
int32 |
ID de Tarea | Task ID. | ||
UID |
guid |
UID | Unique ID of the property. | ||
URL |
varchar2 |
URL | Address being accessed. |
Teclas
| Key | Column | Se refiere a | Kind | Description |
|---|---|---|---|---|
SESSIONIOS_ |
EXECUTION_ |
SYSTEMSQLEXECUTIONS.ID |
Textual | The execution of the statement, once it has been registered.A call is logged while the statement still runs and an execution is listed only after the statement has ended; a statement that fails or is cancelled registers none. |
SESSIONIOS_ |
EXECUTION_ |
SYSTEMSQLEXECUTIONSTEPS.ID |
Textual | The step of the execution, once the execution has been registered.The steps of a statement are listed only after it has ended; a call of a statement that fails or is cancelled names a step that is never listed. |
SESSIONIOS_ |
PROVIDER_ |
SYSTEMDATACONTAINERS. |
Textual | The data container of the call, while that data container is active; the history of calls outlives a data container that was closed. |
SESSIONIOS_ |
STATEMENT_ |
SYSTEMSQLAREA.ID |
Textual | The statement in the SQL area, once its query plan has statistics.A call of the first execution of a statement is logged before the SQL area lists the statement. |
Notas de la Versión
Cambios introducidos en cada versión en las tablas, columnas, atributos y capacidades del controlador: