SESSIONIOS: Data Dictionary Session I/Os
read only
- Katalog:
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.
Es können nur Daten abgerufen werden.
Tabellenspalten
Die Spalten der Tabelle SESSIONIOS sind unten aufgeführt. Jede Spalte hat einen SQL-Datentyp. Beim Einfügen und Aktualisieren muss für jede erforderliche Spalte jederzeit ein neuer Wert angegeben werden der nicht Null ist.
| Name | Datentyp | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
ACTION |
varchar2 |
Action | Action, being either 'READ' or 'WRITE'. | ||
BILLING_ |
varchar2 |
Rechnungs-ID | ID for billing. | ||
BILLING_ |
varchar2 |
Abrechnungspool-Identitäts-ID | Pool identity ID for billing. | ||
BILLING_ |
varchar2 |
Rechnungsreferenz | Reference for billing, such as your cost centers. | ||
BYTES_ |
int64 |
Bytes empfangen | Number of bytes received. | ||
BYTES_ |
int64 |
Bytes gesendet | Number of bytes sent. | ||
CACHE_ |
varchar2 |
Cache-ID | Cache ID. | ||
CALL_ |
varchar2 |
Anruf Sicherer Name | Call safe name of the object. | ||
CLIENT_ |
varchar2 |
Client-ID | Client ID. | ||
DATA_ |
varchar2 |
Datencontaineralias | Alias of the data container. | ||
DATA_ |
varchar2 |
Datenkontainer ID | ID of the data container. | ||
DURATION_ |
double |
CPU-Dauer | CPU duration in milliseconds of the I/O. | ||
DURATION_ |
double |
I/O-Dauer | I/O duration in milliseconds of the I/O. | ||
DURATION_ |
double |
Duration | Duration in milliseconds of the I/O. | ||
DURATION_ |
double |
Schlafdauer | Sleep duration in milliseconds of the I/O. | ||
ERROR_ |
varchar2 |
Fehlermeldung | Error message that occurred during executing the I/O. | ||
ERROR_ |
varchar2 |
Fehlermeldungscode | Error message code that occurred during executing the I/O. | ||
EXECUTION_ |
datetime |
Ausführungsenddatum | Date at which the I/O was ended (UTC). | ||
EXECUTION_ |
guid |
Ausführungs-ID | ID of the SQL execution. | ||
EXECUTION_ |
datetime |
Ausführungsstartdatum | Date at which the I/O was started (UTC). | ||
EXECUTION_ |
int64 |
SQL-Ausführungsschritt-ID | ID of the SQL execution step. | ||
FORWARDED_ |
char |
Weitergeleitet an Customer Service | Indicator whether session I/O was forwarded. | ||
FROM_ |
char |
Aus Anwendungscache | Indicator whether the data was retrieved from application-specific cache. | ||
FROM_ |
char |
Aus Cache | Indicator whether the data was retrieved from any cache. | ||
FROM_ |
char |
Aus Festplatten-Cache | Indicator whether the data was retrieved from disk cache. | ||
FROM_ |
char |
Aus Speichercache | Indicator whether the data was retrieved from memory cache. | ||
GUI_ |
varchar2 |
GUI-Aktion | Action performed within the user interface. | ||
GUI_ |
varchar2 |
Name des GUI-Moduls | Module within the GUI application currently running. | ||
GUI_ |
varchar2 |
GUI-Modul 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 |
Lizenzvertragscode | License contract code. | ||
LICENSE_ |
varchar2 |
ID des Lizenzschlüssels | License key identifier. | ||
MANAGED_ |
int32 |
Verwaltete 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 |
Parameterliste | Parameters. | ||
PARTITION |
varchar2 |
Partition | Specific partition on which the I/O was executed. | ||
POOL_ |
varchar2 |
Pool-Identität | Pool identity. | ||
PROCESS_ |
uint32 |
Prozess-ID | Process ID. | ||
PROVIDER_ |
guid |
Treiber Instanz-UID | Unique ID of the provider instance. | ||
PROVIDER_ |
varchar2 |
Provider | Name of provider. | ||
PUBLIC_ |
varchar2 |
Öffentliche Abfrageparameter | Parameters added to the platform query. | ||
RECURSION_ |
int32 |
Rekursionsstufe | Recursion level. | ||
REMOTE_ |
varchar2 |
Remote-Korrelations-IDs | Remote correlation IDs as a comma-separated list of key, colon, space and value. | ||
REQUEST_ |
varchar2 |
ID der Anfrage | 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-Anweisungs-ID | ID of the SQL statement. | ||
SUCCESSFUL |
char |
Succesful | Indicator whether the I/O completed successfully. | ||
TASK_ |
int32 |
Aufgaben-ID | Task ID. | ||
UID |
guid |
UID | Unique ID of the property. | ||
URL |
varchar2 |
URL | Address being accessed. |
Tasten
| Key | Column | Bezieht sich auf | 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. |
Anmerkungen zu dieser Version
Was hat sich in den Tabellen, Spalten, Attributen und Funktionen des Treibers mit jeder neuen Version geändert: