SYSTEMPREEMPTIVELOADINGPARTITIONS: Data Dictionary Pre-emptive Loading Partitions
read only
- Catalogue :
DataDictionary - Schéma :
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.
Permet uniquement de récupérer des données.
Colonnes de table
Les colonnes de la table SYSTEMPREEMPTIVELOADINGPARTITIONS sont présentées ci-dessous. Chaque colonne possède un type de données SQL. Une nouvelle valeur non nulle doit être fournie pour chaque colonne requise à tout moment lors de l'insertion et de la mise à jour.
| Name | Type de données | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
BYTES_ |
int64 |
Octets écrits | Number of bytes received and written to the local caches on its behalf. | ||
CALLS_ |
int64 |
Appels passés | Number of calls to the platform spent on it so far. | ||
CANDIDATE_ |
int64 |
Candidate | Identity of the candidate this work belongs to.Voir SystemPreemptiveLoadCandidates. | ||
CATALOG_ |
varchar2 |
Catalog | Catalog of the object. | ||
DATA_ |
varchar2 |
Alias du conteneur de données | Alias of the data container. | ||
ESTIMATED_ |
int64 |
Nombre estimé de lignes | Number of rows expected in total, against which the rows loaded read as progress. | ||
FAILURE_ |
int32 |
Nombre d'échecs | Number of times pre-emptive fetching data failed. | ||
FINISHED_ |
datetime |
Date d'achèvement | 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 |
Nombre de pauses | Number of times pre-empty loading was paused to leave the capacity to the user. | ||
ROWS_ |
int64 |
Nombre de lignes chargées | Number of rows brought in so far. | ||
SCHEMA_ |
varchar2 |
Schema | Schema of the object. | ||
STARTED_ |
datetime |
Date de début | 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. |
Clés
| Key | Column | Se réfère à | Kind | Description |
|---|---|---|---|---|
SYSTEMPREEMPTIVELOADINGPARTITIONS_ |
CANDIDATE_ |
SYSTEMPREEMPTIVELOADCANDIDATES.ID |
Key |
Notes de Version
Quels ont été les changements apportés à chaque version au niveau des tables, des colonnes, des attributs et des fonctionnalités du chauffeur :