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'. |
BYTES_RECEIVED |
int64 |
Bytes Received |
☑ |
Number of bytes received. |
BYTES_SENT |
int64 |
Bytes Sent |
☑ |
Number of bytes sent. |
CALL_SAFE_NAME |
string |
Call Safe Name |
☐ |
Call safe name of the object. |
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. |
ID |
int64 |
ID |
☑ |
Unique ID of the property. |
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. |
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. |
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. |
18-10-2024 06:49 Version 24.0.345-PROD+4945