SYSTEMSQLEXECUTIONSLEEPS: Data Dictionary SQL Execution Sleeps
read only
- Catalogus:
DataDictionary - Schema:
Invantive - Label: SQL Execution Sleeps
Sleeps executed by Invantive's UniversalSQL engine during the execution of SQL statements.
Kan alleen gegevens ophalen.
Tabelkolommen
De kolommen van de tabel SYSTEMSQLEXECUTIONSLEEPS 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 |
|---|---|---|---|---|---|
ACTUAL_ |
double |
Werkelijke Duur (ms) | Actual duration in milliseconds of the sleep. | ||
END_ |
datetime |
Eindtijd | Time at which the sleep was completed (UTC). | ||
EXECUTION_ |
uuid |
SQL-Uitvoerings-ID | ID of the SQL execution. | ||
EXECUTION_ |
int64 |
SQL-Uitvoeringsstap-ID | ID of the SQL execution step. | ||
EXPECTED_ |
double |
Verwachte Duur (ms) | Expected duration in milliseconds of the sleep. | ||
ID |
int64 |
ID | Unique ID of the sleep. | ||
MESSAGE_ |
varchar2 |
Berichtcode | Code of the message to indicate the origin. | ||
PARTITION |
varchar2 |
Partition | Specific partition on which the sleep was executed. | ||
START_ |
datetime |
Starttijd | Time at which the sleep was started (UTC). | ||
STATEMENT_ |
uuid |
SQL-Statement ID | ID of the SQL statement. | ||
TABLE_ |
varchar2 |
Tabelnaam | Name of the table. |
Toetsen
| Key | Column | Verwijst naar | Kind | Description |
|---|---|---|---|---|
SYSTEMSQLEXECUTIONSLEEPS_ |
EXECUTION_ |
SYSTEMSQLEXECUTIONS.ID |
Key | |
SYSTEMSQLEXECUTIONSLEEPS_ |
EXECUTION_ |
SYSTEMSQLEXECUTIONSTEPS.ID |
Key | |
SYSTEMSQLEXECUTIONSLEEPS_ |
STATEMENT_ |
SYSTEMSQLAREA.ID |
Key |
Release Notes
Wat is er per release veranderd in de tabellen, kolommen, attributen en mogelijkheden van de driver: