SESSIONIOS: Data Dictionary Session I/Os
read only
- Catalogo:
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.
È possibile solo recuperare i dati.
Colonne della tabella
Di seguito sono riportate le colonne della tabella SESSIONIOS. Ogni colonna ha un tipo di dati SQL. Un nuovo valore non nullo deve essere fornito per ogni colonna richiesta in ogni momento durante l'inserimento e l'aggiornamento.
| Name | Tipo di dati | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
ACTION |
varchar2 |
Action | Action, being either 'READ' or 'WRITE'. | ||
BILLING_ |
varchar2 |
ID di fatturazione | ID for billing. | ||
BILLING_ |
varchar2 |
ID identità del pool di fatturazione | Pool identity ID for billing. | ||
BILLING_ |
varchar2 |
Riferimento di fatturazione | Reference for billing, such as your cost centers. | ||
BYTES_ |
int64 |
Byte ricevuti | Number of bytes received. | ||
BYTES_ |
int64 |
Byte inviati | Number of bytes sent. | ||
CACHE_ |
varchar2 |
ID della memoria | Cache ID. | ||
CALL_ |
varchar2 |
Nome sicuro di chiamata | Call safe name of the object. | ||
CLIENT_ |
varchar2 |
ID del cliente | Client ID. | ||
DATA_ |
varchar2 |
Alias del contenitore di dati | Alias of the data container. | ||
DATA_ |
varchar2 |
ID di contenitore di dati | ID of the data container. | ||
DURATION_ |
double |
Durata della CPU | CPU duration in milliseconds of the I/O. | ||
DURATION_ |
double |
Durata I/O | I/O duration in milliseconds of the I/O. | ||
DURATION_ |
double |
Duration | Duration in milliseconds of the I/O. | ||
DURATION_ |
double |
Durata del sonno | Sleep duration in milliseconds of the I/O. | ||
ERROR_ |
varchar2 |
Messaggio di errore | Error message that occurred during executing the I/O. | ||
ERROR_ |
varchar2 |
Codice del messaggio di errore | Error message code that occurred during executing the I/O. | ||
EXECUTION_ |
datetime |
Data fine esecuzione | Date at which the I/O was ended (UTC). | ||
EXECUTION_ |
guid |
ID di esecuzione | ID of the SQL execution. | ||
EXECUTION_ |
datetime |
Data di inizio dell'esecuzione | Date at which the I/O was started (UTC). | ||
EXECUTION_ |
int64 |
ID del passaggio di esecuzione SQL | ID of the SQL execution step. | ||
FORWARDED_ |
char |
Inoltrato al Customer Service | Indicator whether session I/O was forwarded. | ||
FROM_ |
char |
Dalla cache dell'applicazione | Indicator whether the data was retrieved from application-specific cache. | ||
FROM_ |
char |
Da Cache | Indicator whether the data was retrieved from any cache. | ||
FROM_ |
char |
Dalla cache del disco | Indicator whether the data was retrieved from disk cache. | ||
FROM_ |
char |
Dalla memoria cache | Indicator whether the data was retrieved from memory cache. | ||
GUI_ |
varchar2 |
Azione GUI | Action performed within the user interface. | ||
GUI_ |
varchar2 |
Nome del modulo GUI | Module within the GUI application currently running. | ||
GUI_ |
varchar2 |
Versione del modulo 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 |
Codice del contratto di licenza | License contract code. | ||
LICENSE_ |
varchar2 |
Identificatore della chiave di licenza | License key identifier. | ||
MANAGED_ |
int32 |
ID thread gestito | 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 |
Elenco dei parametri | Parameters. | ||
PARTITION |
varchar2 |
Partition | Specific partition on which the I/O was executed. | ||
POOL_ |
varchar2 |
Identità del pool | Pool identity. | ||
PROCESS_ |
uint32 |
ID del processo | Process ID. | ||
PROVIDER_ |
guid |
UID dell'istanza del provider | Unique ID of the provider instance. | ||
PROVIDER_ |
varchar2 |
Provider | Name of provider. | ||
PUBLIC_ |
varchar2 |
Parametri di interrogazione pubblica | Parameters added to the platform query. | ||
RECURSION_ |
int32 |
Livello di ricorsione | Recursion level. | ||
REMOTE_ |
varchar2 |
ID di correlazione remoti | Remote correlation IDs as a comma-separated list of key, colon, space and value. | ||
REQUEST_ |
varchar2 |
ID richiesta | Request ID. | ||
ROUND_ |
int32 |
Viaggi di andata e ritorno | Number of round trips. | ||
ROW_ |
int64 |
Rows | Number of rows exchanged. | ||
SESSION_ |
varchar2 |
Identificatore di sessione | ID of the session. | ||
STATEMENT_ |
guid |
ID dell'istruzione SQL | ID of the SQL statement. | ||
SUCCESSFUL |
char |
Succesful | Indicator whether the I/O completed successfully. | ||
TASK_ |
int32 |
ID compito | Task ID. | ||
UID |
guid |
UID | Unique ID of the property. | ||
URL |
varchar2 |
URL | Address being accessed. |
Chiavi
| Key | Column | Si riferisce 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. |
Note di rilascio
Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver: