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_ |
int64 |
Candidate | Candidate it raised, or empty when nothing matched. | ||
CATALOG_ |
varchar2 |
Catalog | Catalog named in the announcement, or empty for any. | ||
CONTEXT |
varchar2 |
Anunciado por | Who announced it. | ||
DATA_ |
varchar2 |
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_ |
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_ |
varchar2 |
Ú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_ |
datetime |
Fecha límite para actuar | Moment at which that last happened (UTC). | ||
LAST_ |
varchar2 |
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_ |
int64 |
Número Máximo de Filas | Number of rows which were announced to be read, or empty when the whole table was. | ||
PARTITION_ |
varchar2 |
Partition | Partition announced, or empty for the partitions in scope. | ||
PARTITION_ |
varchar2 |
Á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_ |
datetime |
Fecha de recepción | Moment the announcement was received (UTC). | ||
SCHEMA_ |
varchar2 |
Schema | Schema named in the announcement, or empty for any. | ||
TABLE_ |
varchar2 |
Table | Name of the table announced. | ||
WITHIN_ |
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_ |
SYSTEMPREEMPTIVELOADCANDIDATES.ID |
Key |
Notas de la Versión
Cambios introducidos en cada versión en las tablas, columnas, atributos y capacidades del controlador: