invantive documentation
Invantive Support ForumsAanmelden / Inschrijven

SYSTEMSQLEXECUTIONS: Data Dictionary SQL Executions

read only

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

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

Kan alleen gegevens ophalen.

Tabelkolommen

De kolommen van de tabel SYSTEMSQLEXECUTIONS worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype. Voor elke vereiste kolom moet bij het invoegen en bijwerken steeds een nieuwe, niet-lege waarde worden opgegeven.

Name Datatype Label Required Marks Documentation
BILLING_ID varchar2 Factuur ID ID for billing.
DATA_CONTAINER_ID varchar2(4000) Datacontainer ID Data container ID.
DURATION_MS double Duur (ms) Duration (ms).
DURATION_TICKS int64 Duur (tikken) Duration (ticks).
END_TIME_UTC datetime Eindtijd Time at which the SQL fetch was completed (UTC).
GUI_IP_ADDRESS_EXTERNAL varchar2(240) GUI Extern IP-adres External IP address of the GUI application.
GUI_IP_PORT uint16 GUI Externe IP-poort External IP port of the GUI application.
HEAP_BYTES_ALLOCATED int64 Toegewezen 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) Inkomende Correlatie-ID's Inbound correlation IDs.
IO_BYTES_RECEIVED int64 Bytes Ontvangen Number of bytes received using I/O.
IO_BYTES_SENT int64 Bytes Verzonden Number of bytes sent using I/O.
IO_DURATION_MS double I/O-duur (ms) Duration of I/O (ms).
IO_NUMBER_OF_PARTITIONS int32 Aantal Partities Number of partitions accessed through I/O.
IO_ROW_COUNT int64 I/O Aantal Rijen Number of rows retrieved using I/O.
MANAGED_THREAD_ID int32 Beheerde Thread-ID Managed thread ID.
PARAMETER_VALUES varchar2(4000) Parameterwaarden Parameter values.
REQUEST_ID varchar2(60) Verzoek ID Request ID.
RESULT_SET_NAME varchar2(4000) Naam Resultaatset Name of result set.
ROW_COUNT int64 Rows Number of rows retrieved.
SQL_STATEMENT varchar2 SQL-instructie SQL statement.
START_TIME_UTC datetime Starttijd Time at which the SQL fetch was started (UTC).
STATEMENT_FINGER_PRINT varchar2(240) Vingerafdruk Unique finger print of the SQL statement.
STATEMENT_ID guid Statement-ID Unique ID of the SQL statement.
TASK_ID int32 Taak ID Task ID.
THREAD_CPU_TIME_NS int64 CPU-tijd per 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.

Toetsen

Key Column Verwijst naar Kind Description
SYSTEMSQLEXECUTIONS_STATEMENT_ID_SYSTEMSQLAREA_fk STATEMENT_ID SYSTEMSQLAREA.ID Key

Geciteerd door

Release Notes

Wat is er per release veranderd in de tabellen, kolommen, attributen en mogelijkheden van de driver: