invantive documentation
Foros de Soporte de InvantiveIniciar Sesión / Registrarse

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_PROCESSED int64 Bytes escritos Number of bytes received and written to the local caches on its behalf.
CALLS_SPENT int64 Llamadas realizadas Number of calls to the platform spent on it so far.
CANDIDATE_ID int64 Candidate Identity of the candidate this work belongs to.Ver SystemPreemptiveLoadCandidates.
CATALOG_NAME varchar2(240) Catalog Catalog of the object.
DATA_CONTAINER_ALIAS varchar2(240) Alias del Contenedor de Datos Alias of the data container.
ESTIMATED_NUMBER_OF_ROWS int64 Número Estimado de Filas Number of rows expected in total, against which the rows loaded read as progress.
FAILURE_COUNT int32 Número de fallos Number of times pre-emptive fetching data failed.
FINISHED_DATE_UTC datetime Fecha de finalización Moment the work reached an end (UTC), or empty while it may still run.
LAST_REASON varchar2(1024) Reason Reason last waited for, dropped or given up.
PARTITION_CODE varchar2(240) Partition Partition being fetched, or empty for an object which has no partitions.
PAUSE_COUNT int32 Número de pausas Number of times pre-empty loading was paused to leave the capacity to the user.
ROWS_LOADED int64 Filas cargadas Number of rows brought in so far.
SCHEMA_NAME varchar2(240) Schema Schema of the object.
STARTED_DATE_UTC datetime Fecha de inicio Moment the work started for the first time (UTC), or empty when it never ran.
STATE varchar2(32) State Where it stands: 'Offered', 'Scheduled', 'Running', 'Paused', 'Deferred', 'Done', 'Dropped' or 'Abandoned'.
TABLE_NAME varchar2(240) Table Name of the table, table function or view.

Teclas

Key Column Se refiere a Kind Description
SYSTEMPREEMPTIVELOADINGPARTITIONS_CANDIDATE_ID_SYSTEMPREEMPTIVELOADCANDIDATES_fk CANDIDATE_ID SYSTEMPREEMPTIVELOADCANDIDATES.ID Key

Notas de la Versión

Cambios introducidos en cada versión en las tablas, columnas, atributos y capacidades del controlador: