SYSTEMPREEMPTIVELOADHINTS: Data Dictionary Pre-emptive Load Hints
read only
- Catalogus:
DataDictionary - Schema:
Invantive - Label: Pre-emptive Load Hints
The announcements this session received that a table will be needed shortly, with who announced it and whether a candidate was found for it. Live session state rather than a log.
Kan alleen gegevens ophalen.
Tabelkolommen
De kolommen van de tabel SYSTEMPREEMPTIVELOADHINTS 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 |
|---|---|---|---|---|---|
CANDIDATE_ |
int64 |
Candidate | Candidate it raised, or empty when nothing matched. | ||
CATALOG_ |
varchar2 |
Catalog | Catalog named in the announcement, or empty for any. | ||
CONTEXT |
varchar2 |
Aangekondigd door | Who announced it. | ||
DATA_ |
varchar2 |
Datacontainer Alias | Alias of the data container which is to answer, or empty when every data container offering the object is meant. | ||
EXPIRED_ |
datetime |
Vervaldatum | Moment at which the announcement has decayed to nothing (UTC). | ||
HONOURED |
boolean |
Honoured | Whether a candidate was found for it. | ||
LAST_ |
varchar2 |
Laatste Actie | What was last done with this announcement, in English: recorded, ignored because loading ahead is switched off, matched against a candidate, work added for a partition, no data container offering the object, a partition the data container does not have, or expired unused. | ||
LAST_ |
datetime |
Laatste actiedatum | Moment at which that last happened (UTC). | ||
LAST_ |
varchar2 |
Code van het laatste actiemelding | Message code of what was last done with this announcement, by which the same event is found in a trace. | ||
MAXIMUM_ |
int64 |
Maximum Aantal Rijen | Number of rows which were announced to be read, or empty when the whole table was. | ||
PARTITION_ |
varchar2 |
Partition | Partition announced, or empty for the partitions in scope. | ||
PARTITION_ |
varchar2 |
Toepassingsgebied van de partitie | Which partitions were announced: 'One' for the partition named, 'Selected' for the partitions the session has selected, 'All' for every partition of the data container. | ||
RECEIVED_ |
datetime |
Ontvangstdatum | Moment the announcement was received (UTC). | ||
SCHEMA_ |
varchar2 |
Schema | Schema named in the announcement, or empty for any. | ||
TABLE_ |
varchar2 |
Table | Name of the table announced. | ||
WITHIN_ |
double |
Within | Number of seconds within which it was announced to be needed after receipt. |
Toetsen
| Key | Column | Verwijst naar | Kind | Description |
|---|---|---|---|---|
SYSTEMPREEMPTIVELOADHINTS_ |
CANDIDATE_ |
SYSTEMPREEMPTIVELOADCANDIDATES.ID |
Key |
Release Notes
Wat is er per release veranderd in de tabellen, kolommen, attributen en mogelijkheden van de driver: