SYSTEMPREEMPTIVELOADINGPARTITIONS: Data Dictionary Pre-emptive Loading Partitions
read only
- Catálogo:
DataDictionary - Esquema:
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.
Solo puede recuperar datos.
Columnas de la Tabla
A continuación se muestran las columnas de la tabla SYSTEMPREEMPTIVELOADINGPARTITIONS. 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 |
|---|---|---|---|---|---|
BYTES_ |
int64 |
Bytes escritos | Number of bytes received and written to the local caches on its behalf. | ||
CALLS_ |
int64 |
Llamadas realizadas | Number of calls to the platform spent on it so far. | ||
CANDIDATE_ |
int64 |
Candidate | Identity of the candidate this work belongs to.Ver SystemPreemptiveLoadCandidates. | ||
CATALOG_ |
varchar2 |
Catalog | Catalog of the object. | ||
DATA_ |
varchar2 |
Alias del Contenedor de Datos | Alias of the data container. | ||
ESTIMATED_ |
int64 |
Número Estimado de Filas | Number of rows expected in total, against which the rows loaded read as progress. | ||
FAILURE_ |
int32 |
Número de fallos | Number of times pre-emptive fetching data failed. | ||
FINISHED_ |
datetime |
Fecha de finalización | 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 |
Número de pausas | Number of times pre-empty loading was paused to leave the capacity to the user. | ||
ROWS_ |
int64 |
Filas cargadas | Number of rows brought in so far. | ||
SCHEMA_ |
varchar2 |
Schema | Schema of the object. | ||
STARTED_ |
datetime |
Fecha de inicio | 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. |
Teclas
| Key | Column | Se refiere a | Kind | Description |
|---|---|---|---|---|
SYSTEMPREEMPTIVELOADINGPARTITIONS_ |
CANDIDATE_ |
SYSTEMPREEMPTIVELOADCANDIDATES.ID |
Key |
Notas de la Versión
Cambios introducidos en cada versión en las tablas, columnas, atributos y capacidades del controlador: