invantive documentation
Forum di supporto InvantiveAccedi / Registrati

SYSTEMPREEMPTIVELOADINGPARTITIONS: Data Dictionary Pre-emptive Loading Partitions

read only

  • Catalogo: 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.

È possibile solo recuperare i dati.

Colonne della tabella

Di seguito sono riportate le colonne della tabella SYSTEMPREEMPTIVELOADINGPARTITIONS. Ogni colonna ha un tipo di dati SQL. Un nuovo valore non nullo deve essere fornito per ogni colonna richiesta in ogni momento durante l'inserimento e l'aggiornamento.

Name Tipo di dati Label Required Marks Documentation
BYTES_PROCESSED int64 Byte scritti Number of bytes received and written to the local caches on its behalf.
CALLS_SPENT int64 Chiamate effettuate Number of calls to the platform spent on it so far.
CANDIDATE_ID int64 Candidate Identity of the candidate this work belongs to.Vedere SystemPreemptiveLoadCandidates.
CATALOG_NAME varchar2(240) Catalog Catalog of the object.
DATA_CONTAINER_ALIAS varchar2(240) Alias del contenitore di dati Alias of the data container.
ESTIMATED_NUMBER_OF_ROWS int64 Numero stimato di righe Number of rows expected in total, against which the rows loaded read as progress.
FAILURE_COUNT int32 Numero di errori Number of times pre-emptive fetching data failed.
FINISHED_DATE_UTC datetime Data di completamento 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 Numero di pause Number of times pre-empty loading was paused to leave the capacity to the user.
ROWS_LOADED int64 Righe caricate Number of rows brought in so far.
SCHEMA_NAME varchar2(240) Schema Schema of the object.
STARTED_DATE_UTC datetime Data di inizio 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.

Chiavi

Key Column Si riferisce a Kind Description
SYSTEMPREEMPTIVELOADINGPARTITIONS_CANDIDATE_ID_SYSTEMPREEMPTIVELOADCANDIDATES_fk CANDIDATE_ID SYSTEMPREEMPTIVELOADCANDIDATES.ID Key

Note di rilascio

Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver: