SYSTEMPREEMPTIVELOADHINTS: Data Dictionary Pre-emptive Load Hints
read only
- Catalog:
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.
Can only retrieve data.
Table Columns
The columns of the table SYSTEMPREEMPTIVELOADHINTS are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.
| Name | Data Type | 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 |
Announced By | Who announced it. | ||
DATA_ |
varchar2 |
Data Container Alias | Alias of the data container which is to answer, or empty when every data container offering the object is meant. | ||
EXPIRED_ |
datetime |
Expired Date | Moment at which the announcement has decayed to nothing (UTC). | ||
HONOURED |
boolean |
Honoured | Whether a candidate was found for it. | ||
LAST_ |
varchar2 |
Last 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_ |
datetime |
Last Action Date | Moment at which that last happened (UTC). | ||
LAST_ |
varchar2 |
Last Action Message Code | Message code of what was last done with this announcement, by which the same event is found in a trace. | ||
MAXIMUM_ |
int64 |
Maximum Number of Rows | 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 |
Partition Scope | 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 |
Received Date | 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. |
Keys
| Key | Column | Refers to | Kind | Description |
|---|---|---|---|---|
SYSTEMPREEMPTIVELOADHINTS_ |
CANDIDATE_ |
SYSTEMPREEMPTIVELOADCANDIDATES.ID |
Key |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: