SYSTEMPREEMPTIVELOADCANDIDATES: Data Dictionary Pre-emptive Load Candidates
read only
- Catalogo:
DataDictionary - Schema:
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.
È possibile solo recuperare i dati.
Colonne della tabella
Di seguito sono riportate le colonne della tabella SYSTEMPREEMPTIVELOADCANDIDATES. 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 |
|---|---|---|---|---|---|
ADVISOR |
varchar2 |
A cura di | 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 |
Con la consulenza di Context | Who gave the hint, where a hint advised it. | ||
CATALOG_ |
varchar2 |
Catalog | Catalog of the object. | ||
DATA_ |
varchar2 |
Alias del contenitore di dati | Alias of the data container whose driver proposed it. | ||
ESTIMATED_ |
int64 |
Numero stimato di chiamate | Number of calls one fetch is expected to take, or empty when the driver cannot tell. | ||
ESTIMATED_ |
int64 |
Numero stimato di righe | Number of rows the platform is expected to hold, as far as the driver knows. | ||
FRESHNESS_ |
double |
Età di freschezza | 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 |
Includi al primo utilizzo | Whether a session with no prior history of earlier use by the use fetches this one. | ||
INTEREST_ |
datetime |
Interessi maturati fino alla data | 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 |
Numero massimo di righe | 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 |
Ambito della partizione | 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 |
Punteggio dall'annuncio | Part of the score which comes from an announcement that it will be asked for. | ||
SCORE_ |
double |
Risultati storici | Part of the score which comes from the earlier questions of this user at this time of day. | ||
SCORE_ |
double |
Punteggio rispetto alle aspettative | 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. |
Riferito da
- SYSTEMPREEMPTIVELOADHINTS
CANDIDATE_ID(Key) - SYSTEMPREEMPTIVELOADINGPARTITIONS
CANDIDATE_ID(Key)
Note di rilascio
Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver: