SYSTEMPREEMPTIVELOADHINTS: Data Dictionary Pre-emptive Load Hints
read only
- Catalogue :
DataDictionary - Schéma :
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.
Permet uniquement de récupérer des données.
Colonnes de table
Les colonnes de la table SYSTEMPREEMPTIVELOADHINTS sont présentées ci-dessous. Chaque colonne possède un type de données SQL. Une nouvelle valeur non nulle doit être fournie pour chaque colonne requise à tout moment lors de l'insertion et de la mise à jour.
| Name | Type de données | 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 |
Annoncé par | Who announced it. | ||
DATA_ |
varchar2 |
Alias du conteneur de données | Alias of the data container which is to answer, or empty when every data container offering the object is meant. | ||
EXPIRED_ |
datetime |
Date d'expiration | Moment at which the announcement has decayed to nothing (UTC). | ||
HONOURED |
boolean |
Honoured | Whether a candidate was found for it. | ||
LAST_ |
varchar2 |
Dernière action | 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 |
Date limite d'action | Moment at which that last happened (UTC). | ||
LAST_ |
varchar2 |
Code du dernier message d'action | Message code of what was last done with this announcement, by which the same event is found in a trace. | ||
MAXIMUM_ |
int64 |
Nombre maximal de lignes | 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 |
Portée de la partition | 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 |
Received Date | 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. |
Clés
| Key | Column | Se réfère à | Kind | Description |
|---|---|---|---|---|
SYSTEMPREEMPTIVELOADHINTS_ |
CANDIDATE_ |
SYSTEMPREEMPTIVELOADCANDIDATES.ID |
Key |
Notes de Version
Quels ont été les changements apportés à chaque version au niveau des tables, des colonnes, des attributs et des fonctionnalités du chauffeur :