SYSTEMPREEMPTIVELOADCANDIDATES: Data Dictionary Pre-emptive Load Candidates
read only
- Catalogue :
DataDictionary - Schéma :
Invantive - Label: Pre-emptive Load Candidates
The tables which this session may fetch before they are asked for, with who advised each one, how it is weighed and how many rows of it are wanted. One row per table; how far the fetching got is per partition, in SystemPreemptiveLoadingPartitions. Live session state rather than a log: the list is gone when the session ends.
Permet uniquement de récupérer des données.
Colonnes de table
Les colonnes de la table SYSTEMPREEMPTIVELOADCANDIDATES 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 |
|---|---|---|---|---|---|
ADVISOR |
varchar2 |
Sous la direction de | Who advised it: 'DriverDefault' for the driver of the platform, 'Hint' for something which announced it, and 'Journal' for the earlier questions of this user. | ||
ADVISOR_ |
varchar2 |
Sur les conseils de Context | Who gave the hint, where a hint advised it. | ||
CATALOG_ |
varchar2 |
Catalog | Catalog of the object. | ||
DATA_ |
varchar2 |
Alias du conteneur de données | Alias of the data container whose driver proposed it. | ||
ESTIMATED_ |
int64 |
Nombre estimé d'appels | Number of calls one fetch is expected to take, or empty when the driver cannot tell. | ||
ESTIMATED_ |
int64 |
Nombre estimé de lignes | Number of rows the platform is expected to hold, as far as the driver knows. | ||
FRESHNESS_ |
double |
Âge de fraîcheur | Age in seconds below which what is already cached makes a fetch pointless. | ||
ID |
int64 |
Candidate | Identity of the candidate within the session. | ||
INCLUDE_ |
boolean |
Inclure dès la première utilisation | Whether a session with no prior history of earlier use by the use fetches this one. | ||
INTEREST_ |
datetime |
Intérêts courus jusqu'à la date du | Moment until which it is expected to be asked for (UTC), or empty when the expectation is open-ended. | ||
KIND |
varchar2 |
Kind | What has to be done to fetch it: 'IncrementalRefresh', 'PageSet', 'Blobs' or 'Metadata'. | ||
MAXIMUM_ |
int64 |
Nombre maximal de lignes | Number of rows to fetch, or empty for the whole dataset. | ||
PARTITION_ |
varchar2 |
Partition | The partition it covers, when the scope is one partition; empty when the scope is the selected partitions or all of them, since the partitions are then reported per partition in SystemPreemptiveLoadingPartitions. | ||
PARTITION_ |
varchar2 |
Portée de la partition | Which partitions it covers: 'One', 'Selected' or 'All'. | ||
PRIORITY |
varchar2 |
Priority | Allowance made available: 'Always', 'Normal' or 'Spare'. | ||
SCHEMA_ |
varchar2 |
Schema | Schema of the object. | ||
SCORE |
double |
Score | Calls expected to be saved per call spent, by which candidates are ordered within their priority. | ||
SCORE_ |
double |
Résultat depuis l'annonce | Part of the score which comes from an announcement that it will be asked for. | ||
SCORE_ |
double |
Résultats historiques | Part of the score which comes from the earlier questions of this user at this time of day. | ||
SCORE_ |
double |
Écart par rapport aux prévisions | Part of the score which comes from what the driver expects of this object. | ||
TABLE_ |
varchar2 |
Table | Name of the table, table function or view. |
Référencée
- SYSTEMPREEMPTIVELOADHINTS
CANDIDATE_ID(Key) - SYSTEMPREEMPTIVELOADINGPARTITIONS
CANDIDATE_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 :