invantive documentation
Invantive SupportforenAnmelden / Eintragen

SYSTEMSQLEXECUTIONS: Data Dictionary SQL Executions

read only

  • Katalog: DataDictionary
  • Schema: Invantive
  • Label: SQL Executions

All SQL statement executions, executed by Invantive's UniversalSQL engine.

Es können nur Daten abgerufen werden.

Tabellenspalten

Die Spalten der Tabelle SYSTEMSQLEXECUTIONS 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
BILLING_ID varchar2 Rechnungs-ID ID for billing.
DATA_CONTAINER_ID varchar2(4000) Datenkontainer ID Data container ID.
DURATION_MS double Dauer (ms) Duration (ms).
DURATION_TICKS int64 Dauer (Ticks) Duration (ticks).
END_TIME_UTC datetime Endzeit Time at which the SQL fetch was completed (UTC).
GUI_IP_ADDRESS_EXTERNAL varchar2(240) GUI Externe IP-Adresse External IP address of the GUI application.
GUI_IP_PORT uint16 GUI – Externe IP-Adresse und Port External IP port of the GUI application.
HEAP_BYTES_ALLOCATED int64 Zugewiesene Heap-Bytes Number of bytes allocated on the managed heap by the execution: the sum over the outermost step of every statement of the batch, plus what the workers of a parallel clause allocated on their own threads.Counts bytes allocated rather than bytes retained, so it never decreases.
ID guid ID Unique ID of the execution.
INBOUND_CORRELATION_IDS varchar2(240) Eingehende Korrelations-IDs Inbound correlation IDs.
IO_BYTES_RECEIVED int64 Bytes empfangen Number of bytes received using I/O.
IO_BYTES_SENT int64 Bytes gesendet Number of bytes sent using I/O.
IO_DURATION_MS double I/O-Dauer (ms) Duration of I/O (ms).
IO_NUMBER_OF_PARTITIONS int32 Anzahl der Partitionen Number of partitions accessed through I/O.
IO_ROW_COUNT int64 I/O-Zeilenanzahl Number of rows retrieved using I/O.
MANAGED_THREAD_ID int32 Verwaltete Thread-ID Managed thread ID.
PARAMETER_VALUES varchar2(4000) Parameterwerte Parameter values.
REQUEST_ID varchar2(60) ID der Anfrage Request ID.
RESULT_SET_NAME varchar2(4000) Name des Ergebnissatzes Name of result set.
ROW_COUNT int64 Rows Number of rows retrieved.
SQL_STATEMENT varchar2 SQL Anweisung SQL statement.
START_TIME_UTC datetime Startzeit Time at which the SQL fetch was started (UTC).
STATEMENT_FINGER_PRINT varchar2(240) Fingerabdruck Unique finger print of the SQL statement.
STATEMENT_ID guid Anweisungs-ID Unique ID of the SQL statement.
TASK_ID int32 Aufgaben-ID Task ID.
THREAD_CPU_TIME_NS int64 CPU-Zeit pro Thread (ns) CPU time in nanoseconds, kernel plus user, which the operating system charged to the threads of the execution, including the workers of a parallel clause.CPU time spent rather than wall clock, so a statement which put four workers to work can report more nanoseconds than it lasted.

Tasten

Key Column Bezieht sich auf Kind Description
SYSTEMSQLEXECUTIONS_STATEMENT_ID_SYSTEMSQLAREA_fk STATEMENT_ID SYSTEMSQLAREA.ID Key

Verwiesen von

Anmerkungen zu dieser Version

Was hat sich in den Tabellen, Spalten, Attributen und Funktionen des Treibers mit jeder neuen Version geändert: