invantive documentation
Invantive SupportforenAnmelden / Eintragen

SYSTEMPREEMPTIVELOADHINTS: Data Dictionary Pre-emptive Load Hints

read only

  • Katalog: 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.

Es können nur Daten abgerufen werden.

Tabellenspalten

Die Spalten der Tabelle SYSTEMPREEMPTIVELOADHINTS sind unten aufgeführt. Jede Spalte hat einen SQL-Datentyp. Beim Einfügen und Aktualisieren muss für jede erforderliche Spalte jederzeit ein neuer Wert angegeben werden der nicht Null ist.

Name Datentyp 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) Bekannt gegeben von Who announced it.
DATA_CONTAINER_ALIAS varchar2(240) Datencontaineralias Alias of the data container which is to answer, or empty when every data container offering the object is meant.
EXPIRED_DATE_UTC datetime Verfallsdatum Moment at which the announcement has decayed to nothing (UTC).
HONOURED boolean Honoured Whether a candidate was found for it.
LAST_ACTION varchar2(1024) Letzte Aktion 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 Letzter Stichtag Moment at which that last happened (UTC).
LAST_ACTION_MESSAGE_CODE varchar2(32) Code für die letzte Aktionsmeldung 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 Maximale Anzahl von Reihen 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) Geltungsbereich der 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_DATE_UTC datetime Erhalten am 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.

Tasten

Key Column Bezieht sich auf Kind Description
SYSTEMPREEMPTIVELOADHINTS_CANDIDATE_ID_SYSTEMPREEMPTIVELOADCANDIDATES_fk CANDIDATE_ID SYSTEMPREEMPTIVELOADCANDIDATES.ID Key

Anmerkungen zu dieser Version

Was hat sich in den Tabellen, Spalten, Attributen und Funktionen des Treibers mit jeder neuen Version geändert: