SYSTEMPREEMPTIVELOADINGPARTITIONS: Data Dictionary Pre-emptive Loading Partitions
read only
- Katalog:
DataDictionary - Schema:
Invantive - Label: Pre-emptive Loading Partitions
How far fetching ahead has got, one row per candidate and partition: the state, the rows and calls spent so far, and why it last waited or stopped. Read while a session is idle it shows the loading move. Live session state rather than a log.
Es können nur Daten abgerufen werden.
Tabellenspalten
Die Spalten der Tabelle SYSTEMPREEMPTIVELOADINGPARTITIONS sind unten aufgeführt. Jede Spalte hat einen SQL-Datentyp. Beim Einfügen und Aktualisieren muss für jede erforderliche Spalte jederzeit ein neuer Wert angegeben werden der nicht Null ist.
| Name | Datentyp | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
BYTES_ |
int64 |
Geschriebene Bytes | Number of bytes received and written to the local caches on its behalf. | ||
CALLS_ |
int64 |
Getätigte Anrufe | Number of calls to the platform spent on it so far. | ||
CANDIDATE_ |
int64 |
Candidate | Identity of the candidate this work belongs to.Siehe SystemPreemptiveLoadCandidates. | ||
CATALOG_ |
varchar2 |
Catalog | Catalog of the object. | ||
DATA_ |
varchar2 |
Datencontaineralias | Alias of the data container. | ||
ESTIMATED_ |
int64 |
Geschätzte Reihenanzahl | Number of rows expected in total, against which the rows loaded read as progress. | ||
FAILURE_ |
int32 |
Anzahl der Fehler | Number of times pre-emptive fetching data failed. | ||
FINISHED_ |
datetime |
Fertigstellungsdatum | Moment the work reached an end (UTC), or empty while it may still run. | ||
LAST_ |
varchar2 |
Reason | Reason last waited for, dropped or given up. | ||
PARTITION_ |
varchar2 |
Partition | Partition being fetched, or empty for an object which has no partitions. | ||
PAUSE_ |
int32 |
Anzahl der Pausen | Number of times pre-empty loading was paused to leave the capacity to the user. | ||
ROWS_ |
int64 |
Geladene Zeilen | Number of rows brought in so far. | ||
SCHEMA_ |
varchar2 |
Schema | Schema of the object. | ||
STARTED_ |
datetime |
Startdatum | Moment the work started for the first time (UTC), or empty when it never ran. | ||
STATE |
varchar2 |
State | Where it stands: 'Offered', 'Scheduled', 'Running', 'Paused', 'Deferred', 'Done', 'Dropped' or 'Abandoned'. | ||
TABLE_ |
varchar2 |
Table | Name of the table, table function or view. |
Tasten
| Key | Column | Bezieht sich auf | Kind | Description |
|---|---|---|---|---|
SYSTEMPREEMPTIVELOADINGPARTITIONS_ |
CANDIDATE_ |
SYSTEMPREEMPTIVELOADCANDIDATES.ID |
Key |
Anmerkungen zu dieser Version
Was hat sich in den Tabellen, Spalten, Attributen und Funktionen des Treibers mit jeder neuen Version geändert: