invantive documentation
Invantive SupportforenAnmelden / Eintragen

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_ID varchar2 Rechnungs-ID ID for billing.
BILLING_POOL_IDENTITY_ID varchar2 Abrechnungspool-Identitäts-ID Pool identity ID for billing.
BILLING_REFERENCE varchar2 Rechnungsreferenz Reference for billing, such as your cost centers.
BYTES_RECEIVED int64 Bytes empfangen Number of bytes received.
BYTES_SENT int64 Bytes gesendet Number of bytes sent.
CACHE_ID varchar2(1024) Cache-ID Cache ID.
CALL_SAFE_NAME varchar2 Anruf Sicherer Name Call safe name of the object.
CLIENT_ID varchar2(240) Client-ID Client ID.
DATA_CONTAINER_ALIAS varchar2(240) Datencontaineralias Alias of the data container.
DATA_CONTAINER_ID varchar2 Datenkontainer ID ID of the data container.
DURATION_CPU_MS double CPU-Dauer CPU duration in milliseconds of the I/O.
DURATION_IO_MS double I/O-Dauer I/O duration in milliseconds of the I/O.
DURATION_MS double Duration Duration in milliseconds of the I/O.
DURATION_SLEEP_MS double Schlafdauer Sleep duration in milliseconds of the I/O.
ERROR_MESSAGE varchar2 Fehlermeldung Error message that occurred during executing the I/O.
ERROR_MESSAGE_CODE varchar2 Fehlermeldungscode Error message code that occurred during executing the I/O.
EXECUTION_END_DATE_UTC datetime Ausführungsenddatum Date at which the I/O was ended (UTC).
EXECUTION_ID guid Ausführungs-ID ID of the SQL execution.
EXECUTION_START_DATE_UTC datetime Ausführungsstartdatum Date at which the I/O was started (UTC).
EXECUTION_STEP_ID int64 SQL-Ausführungsschritt-ID ID of the SQL execution step.
FORWARDED_CUSTOMER_SERVICE char Weitergeleitet an Customer Service Indicator whether session I/O was forwarded.
FROM_APPLICATION_CACHE char Aus Anwendungscache Indicator whether the data was retrieved from application-specific cache.
FROM_CACHE char Aus Cache Indicator whether the data was retrieved from any cache.
FROM_DISK_CACHE char Aus Festplatten-Cache Indicator whether the data was retrieved from disk cache.
FROM_MEMORY_CACHE char Aus Speichercache Indicator whether the data was retrieved from memory cache.
GUI_ACTION varchar2(240) GUI-Aktion Action performed within the user interface.
GUI_MODULE_NAME varchar2(240) Name des GUI-Moduls Module within the GUI application currently running.
GUI_MODULE_VERSION varchar2(240) 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_CONTRACT_CODE varchar2 Lizenzvertragscode License contract code.
LICENSE_KEY_IDENTIFIER varchar2 ID des Lizenzschlüssels License key identifier.
MANAGED_THREAD_ID int32 Verwaltete Thread-ID Managed thread ID.
ORIGIN varchar2(32) 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_LIST varchar2 Parameterliste Parameters.
PARTITION varchar2 Partition Specific partition on which the I/O was executed.
POOL_IDENTITY varchar2(60) Pool-Identität Pool identity.
PROCESS_ID uint32 Prozess-ID Process ID.
PROVIDER_INSTANCE_UID guid Treiber Instanz-UID Unique ID of the provider instance.
PROVIDER_NAME varchar2 Provider Name of provider.
PUBLIC_QUERY_PARAMETERS varchar2 Öffentliche Abfrageparameter Parameters added to the platform query.
RECURSION_LEVEL int32 Rekursionsstufe Recursion level.
REMOTE_CORRELATION_IDS varchar2(1024) Remote-Korrelations-IDs Remote correlation IDs as a comma-separated list of key, colon, space and value.
REQUEST_ID varchar2(60) ID der Anfrage Request ID.
ROUND_TRIPS int32 Round-Trips Number of round trips.
ROW_COUNT int64 Rows Number of rows exchanged.
SESSION_ID varchar2(240) Session-ID ID of the session.
STATEMENT_ID guid SQL-Anweisungs-ID ID of the SQL statement.
SUCCESSFUL char Succesful Indicator whether the I/O completed successfully.
TASK_ID 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_ID_SYSTEMSQLEXECUTIONS_txt EXECUTION_ID 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_STEP_ID_SYSTEMSQLEXECUTIONSTEPS_txt EXECUTION_STEP_ID 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_INSTANCE_UID_SYSTEMDATACONTAINERS_txt PROVIDER_INSTANCE_UID SYSTEMDATACONTAINERS.PROVIDER_INSTANCE_UID 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_ID_SYSTEMSQLAREA_txt STATEMENT_ID 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: