invantive documentation
Forum di supporto InvantiveAccedi / Registrati

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_ID int64 Candidate Candidate it raised, or empty when nothing matched.
CATALOG_NAME varchar2(240) Catalog Catalog named in the announcement, or empty for any.
CONTEXT varchar2(240) Annunciato da Who announced it.
DATA_CONTAINER_ALIAS varchar2(240) 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_DATE_UTC 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_ACTION varchar2(1024) 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_ACTION_DATE_UTC datetime Data dell'ultima azione Moment at which that last happened (UTC).
LAST_ACTION_MESSAGE_CODE varchar2(32) 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_NUMBER_OF_ROWS int64 Numero massimo di righe Number of rows which were announced to be read, or empty when the whole table was.
PARTITION_CODE varchar2(240) Partition Partition announced, or empty for the partitions in scope.
PARTITION_SCOPE varchar2(32) 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_DATE_UTC datetime Data di ricezione Moment the announcement was received (UTC).
SCHEMA_NAME varchar2(240) Schema Schema named in the announcement, or empty for any.
TABLE_NAME varchar2(240) Table Name of the table announced.
WITHIN_SEC 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_ID_SYSTEMPREEMPTIVELOADCANDIDATES_fk CANDIDATE_ID SYSTEMPREEMPTIVELOADCANDIDATES.ID Key

Note di rilascio

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