SYSTEMPREEMPTIVELOADHINTS: Data Dictionary Pre-emptive Load Hints
read only
- Catalogo:
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.
È possibile solo recuperare i dati.
Colonne della tabella
Di seguito sono riportate le colonne della tabella SYSTEMPREEMPTIVELOADHINTS. Ogni colonna ha un tipo di dati SQL. Un nuovo valore non nullo deve essere fornito per ogni colonna richiesta in ogni momento durante l'inserimento e l'aggiornamento.
| Name | Tipo di dati | 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 |
Annunciato da | Who announced it. | ||
DATA_ |
varchar2 |
Alias del contenitore di dati | Alias of the data container which is to answer, or empty when every data container offering the object is meant. | ||
EXPIRED_ |
datetime |
Data di scadenza | Moment at which the announcement has decayed to nothing (UTC). | ||
HONOURED |
boolean |
Honoured | Whether a candidate was found for it. | ||
LAST_ |
varchar2 |
Ultima azione | 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 |
Data dell'ultima azione | Moment at which that last happened (UTC). | ||
LAST_ |
varchar2 |
Codice dell'ultimo messaggio di azione | Message code of what was last done with this announcement, by which the same event is found in a trace. | ||
MAXIMUM_ |
int64 |
Numero massimo di righe | 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 |
Ambito della partizione | 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 |
Data di ricezione | 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. |
Chiavi
| Key | Column | Si riferisce a | Kind | Description |
|---|---|---|---|---|
SYSTEMPREEMPTIVELOADHINTS_ |
CANDIDATE_ |
SYSTEMPREEMPTIVELOADCANDIDATES.ID |
Key |
Note di rilascio
Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver: