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_ |
varchar2 |
Factuur ID | ID for billing. | ||
DATA_ |
varchar2 |
Datacontainer ID | Data container ID. | ||
DURATION_ |
double |
Duur (ms) | Duration (ms). | ||
DURATION_ |
int64 |
Duur (tikken) | Duration (ticks). | ||
END_ |
datetime |
Eindtijd | Time at which the SQL fetch was completed (UTC). | ||
GUI_ |
varchar2 |
GUI Extern IP-adres | External IP address of the GUI application. | ||
GUI_ |
uint16 |
GUI Externe IP-poort | External IP port of the GUI application. | ||
HEAP_ |
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_ |
varchar2 |
Inkomende Correlatie-ID's | Inbound correlation IDs. | ||
IO_ |
int64 |
Bytes Ontvangen | Number of bytes received using I/O. | ||
IO_ |
int64 |
Bytes Verzonden | Number of bytes sent using I/O. | ||
IO_ |
double |
I/O-duur (ms) | Duration of I/O (ms). | ||
IO_ |
int32 |
Aantal Partities | Number of partitions accessed through I/O. | ||
IO_ |
int64 |
I/O Aantal Rijen | Number of rows retrieved using I/O. | ||
MANAGED_ |
int32 |
Beheerde Thread-ID | Managed thread ID. | ||
PARAMETER_ |
varchar2 |
Parameterwaarden | Parameter values. | ||
REQUEST_ |
varchar2 |
Verzoek ID | Request ID. | ||
RESULT_ |
varchar2 |
Naam Resultaatset | Name of result set. | ||
ROW_ |
int64 |
Rows | Number of rows retrieved. | ||
SQL_ |
varchar2 |
SQL-instructie | SQL statement. | ||
START_ |
datetime |
Starttijd | Time at which the SQL fetch was started (UTC). | ||
STATEMENT_ |
varchar2 |
Vingerafdruk | Unique finger print of the SQL statement. | ||
STATEMENT_ |
guid |
Statement-ID | Unique ID of the SQL statement. | ||
TASK_ |
int32 |
Taak ID | Task ID. | ||
THREAD_ |
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_ |
SYSTEMSQLAREA.ID |
Key |
Geciteerd door
- SESSIONIOS
EXECUTION_ID(Textual) - SYSTEMSQLEXECUTIONSLEEPS
EXECUTION_ID(Key) - SYSTEMSQLEXECUTIONSTEPS
EXECUTION_ID(Key)
Release Notes
Wat is er per release veranderd in de tabellen, kolommen, attributen en mogelijkheden van de driver: