SESSIONIOS: Data Dictionary Session I/Os
read only
- Catalogue :
DataDictionary - Schéma :
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.
Permet uniquement de récupérer des données.
Colonnes de table
Les colonnes de la table SESSIONIOS sont présentées ci-dessous. Chaque colonne possède un type de données SQL. Une nouvelle valeur non nulle doit être fournie pour chaque colonne requise à tout moment lors de l'insertion et de la mise à jour.
| Name | Type de données | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
ACTION |
varchar2 |
Action | Action, being either 'READ' or 'WRITE'. | ||
BILLING_ |
varchar2 |
ID de facturation | ID for billing. | ||
BILLING_ |
varchar2 |
Identifiant du groupe de facturation | Pool identity ID for billing. | ||
BILLING_ |
varchar2 |
Référence de facturation | Reference for billing, such as your cost centers. | ||
BYTES_ |
int64 |
Octets reçus | Number of bytes received. | ||
BYTES_ |
int64 |
Octets envoyés | Number of bytes sent. | ||
CACHE_ |
varchar2 |
ID du cache | Cache ID. | ||
CALL_ |
varchar2 |
Nom de l'appel sécurisé | Call safe name of the object. | ||
CLIENT_ |
varchar2 |
Id du client | Client ID. | ||
DATA_ |
varchar2 |
Alias du conteneur de données | Alias of the data container. | ||
DATA_ |
varchar2 |
ID du conteneur de données | ID of the data container. | ||
DURATION_ |
double |
Durée d'utilisation du processeur | CPU duration in milliseconds of the I/O. | ||
DURATION_ |
double |
Durée des opérations d'E/S | I/O duration in milliseconds of the I/O. | ||
DURATION_ |
double |
Duration | Duration in milliseconds of the I/O. | ||
DURATION_ |
double |
Durée du sommeil | Sleep duration in milliseconds of the I/O. | ||
ERROR_ |
varchar2 |
Message d'Erreur | Error message that occurred during executing the I/O. | ||
ERROR_ |
varchar2 |
Code du message d'erreur | Error message code that occurred during executing the I/O. | ||
EXECUTION_ |
datetime |
Date de fin d'exécution | Date at which the I/O was ended (UTC). | ||
EXECUTION_ |
guid |
ID d'exécution | ID of the SQL execution. | ||
EXECUTION_ |
datetime |
Date de début d'exécution | Date at which the I/O was started (UTC). | ||
EXECUTION_ |
int64 |
ID de l'étape d'exécution SQL | ID of the SQL execution step. | ||
FORWARDED_ |
char |
Transmis au Customer Service | Indicator whether session I/O was forwarded. | ||
FROM_ |
char |
À partir du cache d'application | Indicator whether the data was retrieved from application-specific cache. | ||
FROM_ |
char |
Depuis le cache | Indicator whether the data was retrieved from any cache. | ||
FROM_ |
char |
À partir du cache disque | Indicator whether the data was retrieved from disk cache. | ||
FROM_ |
char |
À partir du cache mémoire | Indicator whether the data was retrieved from memory cache. | ||
GUI_ |
varchar2 |
Action GUI | Action performed within the user interface. | ||
GUI_ |
varchar2 |
Nom du module GUI | Module within the GUI application currently running. | ||
GUI_ |
varchar2 |
Version du module graphique | 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 |
Code du contrat de licence | License contract code. | ||
LICENSE_ |
varchar2 |
Identifiant de la clé de licence | License key identifier. | ||
MANAGED_ |
int32 |
ID du fil géré | 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 |
Liste des paramètres | Parameters. | ||
PARTITION |
varchar2 |
Partition | Specific partition on which the I/O was executed. | ||
POOL_ |
varchar2 |
Identité du Pool | Pool identity. | ||
PROCESS_ |
uint32 |
ID du processus | Process ID. | ||
PROVIDER_ |
guid |
UID de l'instance du fournisseur | Unique ID of the provider instance. | ||
PROVIDER_ |
varchar2 |
Provider | Name of provider. | ||
PUBLIC_ |
varchar2 |
Paramètres de requête publique | Parameters added to the platform query. | ||
RECURSION_ |
int32 |
Niveau de récursivité | Recursion level. | ||
REMOTE_ |
varchar2 |
Identifiants de corrélation à distance | Remote correlation IDs as a comma-separated list of key, colon, space and value. | ||
REQUEST_ |
varchar2 |
ID de demande | Request ID. | ||
ROUND_ |
int32 |
Allers-retours | Number of round trips. | ||
ROW_ |
int64 |
Rows | Number of rows exchanged. | ||
SESSION_ |
varchar2 |
Session ID | ID of the session. | ||
STATEMENT_ |
guid |
ID de l'instruction SQL | ID of the SQL statement. | ||
SUCCESSFUL |
char |
Succesful | Indicator whether the I/O completed successfully. | ||
TASK_ |
int32 |
ID de Tâche | Task ID. | ||
UID |
guid |
UID | Unique ID of the property. | ||
URL |
varchar2 |
URL | Address being accessed. |
Clés
| Key | Column | Se réfère à | 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. |
Notes de Version
Quels ont été les changements apportés à chaque version au niveau des tables, des colonnes, des attributs et des fonctionnalités du chauffeur :