SESSIONIOS: Data Dictionary Session I/Os
read only
- Catalog:
DataDictionary - Schema:
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.
Can only retrieve data.
Table Columns
The columns of the table SESSIONIOS are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.
| Name | Data Type | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
ACTION |
varchar2 |
Action | Action, being either 'READ' or 'WRITE'. | ||
BILLING_ |
varchar2 |
Billing ID | ID for billing. | ||
BILLING_ |
varchar2 |
Billing Pool Identity ID | Pool identity ID for billing. | ||
BILLING_ |
varchar2 |
Billing Reference | Reference for billing, such as your cost centers. | ||
BYTES_ |
int64 |
Bytes Received | Number of bytes received. | ||
BYTES_ |
int64 |
Bytes Sent | Number of bytes sent. | ||
CACHE_ |
varchar2 |
Cache ID | Cache ID. | ||
CALL_ |
varchar2 |
Call Safe Name | Call safe name of the object. | ||
CLIENT_ |
varchar2 |
Client ID | Client ID. | ||
DATA_ |
varchar2 |
Data Container Alias | Alias of the data container. | ||
DATA_ |
varchar2 |
Data Container ID | ID of the data container. | ||
DURATION_ |
double |
CPU Duration | CPU duration in milliseconds of the I/O. | ||
DURATION_ |
double |
I/O Duration | I/O duration in milliseconds of the I/O. | ||
DURATION_ |
double |
Duration | Duration in milliseconds of the I/O. | ||
DURATION_ |
double |
Sleep Duration | Sleep duration in milliseconds of the I/O. | ||
ERROR_ |
varchar2 |
Error Message | Error message that occurred during executing the I/O. | ||
ERROR_ |
varchar2 |
Error Message Code | Error message code that occurred during executing the I/O. | ||
EXECUTION_ |
datetime |
Execution End Date | Date at which the I/O was ended (UTC). | ||
EXECUTION_ |
guid |
Execution ID | ID of the SQL execution. | ||
EXECUTION_ |
datetime |
Execution Start Date | Date at which the I/O was started (UTC). | ||
EXECUTION_ |
int64 |
SQL Execution Step ID | ID of the SQL execution step. | ||
FORWARDED_ |
char |
Forwarded to Customer Service | Indicator whether session I/O was forwarded. | ||
FROM_ |
char |
From Application Cache | Indicator whether the data was retrieved from application-specific cache. | ||
FROM_ |
char |
From Cache | Indicator whether the data was retrieved from any cache. | ||
FROM_ |
char |
From Disk Cache | Indicator whether the data was retrieved from disk cache. | ||
FROM_ |
char |
From Memory Cache | Indicator whether the data was retrieved from memory cache. | ||
GUI_ |
varchar2 |
GUI Action | Action performed within the user interface. | ||
GUI_ |
varchar2 |
GUI Module Name | Module within the GUI application currently running. | ||
GUI_ |
varchar2 |
GUI Module Version | 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 |
License Contract Code | License contract code. | ||
LICENSE_ |
varchar2 |
License Key Identifier | License key identifier. | ||
MANAGED_ |
int32 |
Managed Thread ID | 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 |
Parameter List | Parameters. | ||
PARTITION |
varchar2 |
Partition | Specific partition on which the I/O was executed. | ||
POOL_ |
varchar2 |
Pool Identity | Pool identity. | ||
PROCESS_ |
uint32 |
Process ID | Process ID. | ||
PROVIDER_ |
guid |
Provider Instance UID | Unique ID of the provider instance. | ||
PROVIDER_ |
varchar2 |
Provider | Name of provider. | ||
PUBLIC_ |
varchar2 |
Public Query Parameters | Parameters added to the platform query. | ||
RECURSION_ |
int32 |
Recursion Level | Recursion level. | ||
REMOTE_ |
varchar2 |
Remote Correlation IDs | Remote correlation IDs as a comma-separated list of key, colon, space and value. | ||
REQUEST_ |
varchar2 |
Request ID | Request ID. | ||
ROUND_ |
int32 |
Round Trips | Number of round trips. | ||
ROW_ |
int64 |
Rows | Number of rows exchanged. | ||
SESSION_ |
varchar2 |
Session ID | ID of the session. | ||
STATEMENT_ |
guid |
SQL Statement ID | ID of the SQL statement. | ||
SUCCESSFUL |
char |
Succesful | Indicator whether the I/O completed successfully. | ||
TASK_ |
int32 |
Task ID | Task ID. | ||
UID |
guid |
UID | Unique ID of the property. | ||
URL |
varchar2 |
URL | Address being accessed. |
Keys
| Key | Column | Refers to | 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. |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: