invantive documentation
Forums d'Invantive SupportConnectez-vous/inscrivez-vous

SYSTEMPREEMPTIVELOADHINTS: Data Dictionary Pre-emptive Load Hints

read only

  • Catalogue : DataDictionary
  • Schéma : 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.

Permet uniquement de récupérer des données.

Colonnes de table

Les colonnes de la table SYSTEMPREEMPTIVELOADHINTS sont présentées ci-dessous. Chaque colonne possède un type de données SQL. Une nouvelle valeur non nulle doit être fournie pour chaque colonne requise à tout moment lors de l'insertion et de la mise à jour.

Name Type de données 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) Annoncé par Who announced it.
DATA_CONTAINER_ALIAS varchar2(240) Alias du conteneur de données Alias of the data container which is to answer, or empty when every data container offering the object is meant.
EXPIRED_DATE_UTC datetime Date d'expiration Moment at which the announcement has decayed to nothing (UTC).
HONOURED boolean Honoured Whether a candidate was found for it.
LAST_ACTION varchar2(1024) Dernière action 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 Date limite d'action Moment at which that last happened (UTC).
LAST_ACTION_MESSAGE_CODE varchar2(32) Code du dernier message d'action 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 Nombre maximal de lignes 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) Portée de la 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 Received Date 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.

Clés

Key Column Se réfère à Kind Description
SYSTEMPREEMPTIVELOADHINTS_CANDIDATE_ID_SYSTEMPREEMPTIVELOADCANDIDATES_fk CANDIDATE_ID SYSTEMPREEMPTIVELOADCANDIDATES.ID Key

Notes de Version

Quels ont été les changements apportés à chaque version au niveau des tables, des colonnes, des attributs et des fonctionnalités du chauffeur :