invantive documentation
Forum di supporto InvantiveAccedi / Registrati

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(32) 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_CONTEXT varchar2(240) Con la consulenza di Context Who gave the hint, where a hint advised it.
CATALOG_NAME varchar2(240) Catalog Catalog of the object.
DATA_CONTAINER_ALIAS varchar2(240) Alias del contenitore di dati Alias of the data container whose driver proposed it.
ESTIMATED_NUMBER_OF_CALLS int64 Numero stimato di chiamate Number of calls one fetch is expected to take, or empty when the driver cannot tell.
ESTIMATED_NUMBER_OF_ROWS int64 Numero stimato di righe Number of rows the platform is expected to hold, as far as the driver knows.
FRESHNESS_AGE_SEC 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_ON_FIRST_USE boolean Includi al primo utilizzo Whether a session with no prior history of earlier use by the use fetches this one.
INTEREST_UNTIL_DATE_UTC 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(32) Kind What has to be done to fetch it: 'IncrementalRefresh', 'PageSet', 'Blobs' or 'Metadata'.
MAXIMUM_NUMBER_OF_ROWS int64 Numero massimo di righe Number of rows to fetch, or empty for the whole dataset.
PARTITION_CODE varchar2(240) 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_SCOPE varchar2(32) Ambito della partizione Which partitions it covers: 'One', 'Selected' or 'All'.
PRIORITY varchar2(32) Priority Allowance made available: 'Always', 'Normal' or 'Spare'.
SCHEMA_NAME varchar2(240) 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_FROM_HINT double Punteggio dall'annuncio Part of the score which comes from an announcement that it will be asked for.
SCORE_FROM_JOURNAL double Risultati storici Part of the score which comes from the earlier questions of this user at this time of day.
SCORE_FROM_PRIOR double Punteggio rispetto alle aspettative Part of the score which comes from what the driver expects of this object.
TABLE_NAME varchar2(240) Table Name of the table, table function or view.

Riferito da

Note di rilascio

Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver: