SYSTEMPREEMPTIVELOADINGPARTITIONS: Data Dictionary Pre-emptive Loading Partitions
read only
- Catalogus:
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.
Kan alleen gegevens ophalen.
Tabelkolommen
De kolommen van de tabel SYSTEMPREEMPTIVELOADINGPARTITIONS worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype. Voor elke vereiste kolom moet bij het invoegen en bijwerken steeds een nieuwe, niet-lege waarde worden opgegeven.
| Name | Datatype | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
BYTES_ |
int64 |
Aantal geschreven bytes | Number of bytes received and written to the local caches on its behalf. | ||
CALLS_ |
int64 |
Gespreksduur | Number of calls to the platform spent on it so far. | ||
CANDIDATE_ |
int64 |
Candidate | Identity of the candidate this work belongs to.Zie SystemPreemptiveLoadCandidates. | ||
CATALOG_ |
varchar2 |
Catalog | Catalog of the object. | ||
DATA_ |
varchar2 |
Datacontainer Alias | Alias of the data container. | ||
ESTIMATED_ |
int64 |
Geschat Aantal Rijen | Number of rows expected in total, against which the rows loaded read as progress. | ||
FAILURE_ |
int32 |
Aantal Mislukkingen | Number of times pre-emptive fetching data failed. | ||
FINISHED_ |
datetime |
Voltooid op | 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 |
Aantal Pauzes | Number of times pre-empty loading was paused to leave the capacity to the user. | ||
ROWS_ |
int64 |
Rijen Geladen | 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. |
Toetsen
| Key | Column | Verwijst naar | Kind | Description |
|---|---|---|---|---|
SYSTEMPREEMPTIVELOADINGPARTITIONS_ |
CANDIDATE_ |
SYSTEMPREEMPTIVELOADCANDIDATES.ID |
Key |
Release Notes
Wat is er per release veranderd in de tabellen, kolommen, attributen en mogelijkheden van de driver: