SESSIONIOS: Data Dictionary 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.
Catalog: DataDictionary
Schema: Invantive
Alias: sio
Label: Session I/Os
This is a read-only view. The Data Dictionary API may not support changing the data or the Invantive UniversalSQL driver for Data Dictionary does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Data Dictionary API.
View Columns
The columns of the view SESSIONIOS are shown below. Each column has an SQL data type.
Name |
Data Type |
Label |
Required |
Documentation |
---|---|---|---|---|
ACTION |
string |
Action |
☑ |
Action, being either 'READ' or 'WRITE'. |
BILLING_ID |
string |
Billing ID |
☐ |
ID for billing. |
BILLING_POOL_IDENTITY_ID |
string |
Billing Pool Identity ID |
☐ |
Pool identity ID for billing. |
BILLING_REFERENCE |
string |
Billing Reference |
☐ |
Reference for billing, such as your cost centers. |
BYTES_RECEIVED |
int64 |
Bytes Received |
☑ |
Number of bytes received. |
BYTES_SENT |
int64 |
Bytes Sent |
☑ |
Number of bytes sent. |
CACHE_ID |
string(1024) |
Cache ID |
☐ |
Cache ID. |
CALL_SAFE_NAME |
string |
Call Safe Name |
☐ |
Call safe name of the object. |
CLIENT_ID |
string(240) |
Client ID |
☐ |
Client ID. |
DATA_CONTAINER_ALIAS |
string(240) |
Data Container Alias |
☐ |
Alias of the data container. |
DATA_CONTAINER_ID |
string |
Data Container ID |
☑ |
ID of the data container. |
DURATION_CPU_MS |
int64 |
CPU Duration |
☑ |
CPU duration in milliseconds of the I/O. |
DURATION_IO_MS |
int64 |
I/O Duration |
☑ |
I/O duration in milliseconds of the I/O. |
DURATION_MS |
int64 |
Duration |
☑ |
Duration in milliseconds of the I/O. |
DURATION_SLEEP_MS |
int64 |
Sleep Duration |
☑ |
Sleep duration in milliseconds of the I/O. |
ERROR_MESSAGE_CODE |
string |
Error Message Code |
☐ |
Error message code that occurred during executing the I/O. |
ERROR_MESSAGE |
string |
Error Message |
☐ |
Error message that occurred during executing the I/O. |
EXECUTION_END_DATE_UTC |
datetime |
Execution End Date |
☑ |
Date at which the I/O was ended (UTC). |
EXECUTION_ID |
guid |
Execution ID |
☐ |
ID of the SQL execution. |
EXECUTION_START_DATE_UTC |
datetime |
Execution Start Date |
☑ |
Date at which the I/O was started (UTC). |
EXECUTION_STEP_ID |
int64 |
SQL Execution Step ID |
☐ |
ID of the SQL execution step. |
FORWARDED_CUSTOMER_SERVICE |
boolean |
Forwarded to Customer Service |
☑ |
Indicator whether session I/O was forwarded. |
FROM_APPLICATION_CACHE |
boolean |
From Application Cache |
☑ |
Indicator whether the data was retrieved from application-specific cache. |
FROM_CACHE |
boolean |
From Cache |
☑ |
Indicator whether the data was retrieved from any cache. |
FROM_DISK_CACHE |
boolean |
From Disk Cache |
☑ |
Indicator whether the data was retrieved from disk cache. |
FROM_MEMORY_CACHE |
boolean |
From Memory Cache |
☑ |
Indicator whether the data was retrieved from memory cache. |
GUI_ACTION |
string(240) |
GUI Action |
☐ |
Action performed within the user interface. |
GUI_MODULE_NAME |
string(240) |
GUI Module Name |
☐ |
Module within the GUI application currently running. |
GUI_MODULE_VERSION |
string(240) |
GUI Module Version |
☐ |
Version of module within the GUI application currently running. |
ID |
int64 |
ID |
☑ |
Unique ID of the property. |
IIID |
string |
IIID |
☑ |
Invantive installation ID. |
IUID |
string |
IUID |
☑ |
Invantive user ID. |
LICENSE_CONTRACT_CODE |
string |
License Contract Code |
☐ |
License contract code. |
LICENSE_KEY_IDENTIFIER |
string |
License Key Identifier |
☐ |
License key identifier. |
MANAGED_THREAD_ID |
int32 |
Managed Thread ID |
☐ |
Managed thread ID. |
PARAMETER_LIST |
string |
Parameter List |
☐ |
Parameters. |
PARTITION |
string |
Partition |
☐ |
Specific partition on which the I/O was executed. |
POOL_IDENTITY |
string(60) |
Pool Identity |
☐ |
Pool identity. |
PROCESS_ID |
uint32 |
Process ID |
☐ |
Process ID. |
PROVIDER_INSTANCE_UID |
guid |
Provider Instance UID |
☐ |
Unique ID of the provider instance. |
PROVIDER_NAME |
string |
Provider |
☑ |
Name of provider. |
PUBLIC_QUERY_PARAMETERS |
string |
Public Query Parameters |
☐ |
Parameters added to the platform query. |
RECURSION_LEVEL |
int32 |
Recursion Level |
☑ |
Recursion level. |
REQUEST_ID |
string(60) |
Request ID |
☐ |
Request ID. |
ROUND_TRIPS |
int32 |
Round Trips |
☑ |
Number of round trips. |
ROW_COUNT |
int64 |
Rows |
☐ |
Number of rows exchanged. |
SESSION_ID |
string(240) |
Session ID |
☑ |
ID of the session. |
STATEMENT_ID |
guid |
SQL Statement ID |
☐ |
ID of the SQL statement. |
SUCCESSFUL |
boolean |
Succesful |
☑ |
Indicator whether the I/O completed successfully. |
TASK_ID |
int32 |
Task ID |
☐ |
Task ID. |
UID |
guid |
UID |
☑ |
Unique ID of the property. |
URL |
string |
URL |
☐ |
Address being accessed. |
28-07-2024 17:46 Version 24.1.6-BETA+4856