invantive documentation
Invantive Support ForumsAanmelden / Inschrijven

SYSTEMPREEMPTIVELOADHINTS: Data Dictionary Pre-emptive Load Hints

read only

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

Kan alleen gegevens ophalen.

Tabelkolommen

De kolommen van de tabel SYSTEMPREEMPTIVELOADHINTS worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype. Voor elke vereiste kolom moet bij het invoegen en bijwerken steeds een nieuwe, niet-lege waarde worden opgegeven.

Name Datatype 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) Aangekondigd door Who announced it.
DATA_CONTAINER_ALIAS varchar2(240) Datacontainer Alias Alias of the data container which is to answer, or empty when every data container offering the object is meant.
EXPIRED_DATE_UTC datetime Vervaldatum Moment at which the announcement has decayed to nothing (UTC).
HONOURED boolean Honoured Whether a candidate was found for it.
LAST_ACTION varchar2(1024) Laatste Actie 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 Laatste actiedatum Moment at which that last happened (UTC).
LAST_ACTION_MESSAGE_CODE varchar2(32) Code van het laatste actiemelding 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 Maximum Aantal Rijen 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) Toepassingsgebied van de partitie 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 Ontvangstdatum 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.

Toetsen

Key Column Verwijst naar Kind Description
SYSTEMPREEMPTIVELOADHINTS_CANDIDATE_ID_SYSTEMPREEMPTIVELOADCANDIDATES_fk CANDIDATE_ID SYSTEMPREEMPTIVELOADCANDIDATES.ID Key

Release Notes

Wat is er per release veranderd in de tabellen, kolommen, attributen en mogelijkheden van de driver: