invantive documentation
Foros de Soporte de InvantiveIniciar Sesión / Registrarse

SYSTEMPREEMPTIVELOADHINTS: Data Dictionary Pre-emptive Load Hints

read only

  • Catálogo: DataDictionary
  • Esquema: 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.

Solo puede recuperar datos.

Columnas de la Tabla

A continuación se muestran las columnas de la tabla SYSTEMPREEMPTIVELOADHINTS. Cada columna tiene un tipo de datos SQL. Se debe proporcionar un nuevo valor no nulo para cada columna requerida en todo momento durante la inserción y la actualización.

Name Tipo de Datos 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) Anunciado por Who announced it.
DATA_CONTAINER_ALIAS varchar2(240) Alias del Contenedor de Datos Alias of the data container which is to answer, or empty when every data container offering the object is meant.
EXPIRED_DATE_UTC datetime Fecha de caducidad Moment at which the announcement has decayed to nothing (UTC).
HONOURED boolean Honoured Whether a candidate was found for it.
LAST_ACTION varchar2(1024) Última Acción 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 Fecha límite para actuar Moment at which that last happened (UTC).
LAST_ACTION_MESSAGE_CODE varchar2(32) Código del último mensaje de acción 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 Número Máximo de Filas 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) Ámbito de la partición 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 Fecha de recepción 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.

Teclas

Key Column Se refiere a Kind Description
SYSTEMPREEMPTIVELOADHINTS_CANDIDATE_ID_SYSTEMPREEMPTIVELOADCANDIDATES_fk CANDIDATE_ID SYSTEMPREEMPTIVELOADCANDIDATES.ID Key

Notas de la Versión

Cambios introducidos en cada versión en las tablas, columnas, atributos y capacidades del controlador: