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_ |
varchar2 |
Rechnungs-ID | ID for billing. | ||
DATA_ |
varchar2 |
Datenkontainer ID | Data container ID. | ||
DURATION_ |
double |
Dauer (ms) | Duration (ms). | ||
DURATION_ |
int64 |
Dauer (Ticks) | Duration (ticks). | ||
END_ |
datetime |
Endzeit | Time at which the SQL fetch was completed (UTC). | ||
GUI_ |
varchar2 |
GUI Externe IP-Adresse | External IP address of the GUI application. | ||
GUI_ |
uint16 |
GUI – Externe IP-Adresse und Port | External IP port of the GUI application. | ||
HEAP_ |
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_ |
varchar2 |
Eingehende Korrelations-IDs | Inbound correlation IDs. | ||
IO_ |
int64 |
Bytes empfangen | Number of bytes received using I/O. | ||
IO_ |
int64 |
Bytes gesendet | Number of bytes sent using I/O. | ||
IO_ |
double |
I/O-Dauer (ms) | Duration of I/O (ms). | ||
IO_ |
int32 |
Anzahl der Partitionen | Number of partitions accessed through I/O. | ||
IO_ |
int64 |
I/O-Zeilenanzahl | Number of rows retrieved using I/O. | ||
MANAGED_ |
int32 |
Verwaltete Thread-ID | Managed thread ID. | ||
PARAMETER_ |
varchar2 |
Parameterwerte | Parameter values. | ||
REQUEST_ |
varchar2 |
ID der Anfrage | Request ID. | ||
RESULT_ |
varchar2 |
Name des Ergebnissatzes | Name of result set. | ||
ROW_ |
int64 |
Rows | Number of rows retrieved. | ||
SQL_ |
varchar2 |
SQL Anweisung | SQL statement. | ||
START_ |
datetime |
Startzeit | Time at which the SQL fetch was started (UTC). | ||
STATEMENT_ |
varchar2 |
Fingerabdruck | Unique finger print of the SQL statement. | ||
STATEMENT_ |
guid |
Anweisungs-ID | Unique ID of the SQL statement. | ||
TASK_ |
int32 |
Aufgaben-ID | Task ID. | ||
THREAD_ |
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_ |
SYSTEMSQLAREA.ID |
Key |
Verwiesen von
- SESSIONIOS
EXECUTION_ID(Textual) - SYSTEMSQLEXECUTIONSLEEPS
EXECUTION_ID(Key) - SYSTEMSQLEXECUTIONSTEPS
EXECUTION_ID(Key)
Anmerkungen zu dieser Version
Was hat sich in den Tabellen, Spalten, Attributen und Funktionen des Treibers mit jeder neuen Version geändert: