invantive documentation
Forums d'Invantive SupportConnectez-vous/inscrivez-vous

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_PROCESSED int64 Octets écrits Number of bytes received and written to the local caches on its behalf.
CALLS_SPENT int64 Appels passés Number of calls to the platform spent on it so far.
CANDIDATE_ID int64 Candidate Identity of the candidate this work belongs to.Voir SystemPreemptiveLoadCandidates.
CATALOG_NAME varchar2(240) Catalog Catalog of the object.
DATA_CONTAINER_ALIAS varchar2(240) Alias du conteneur de données Alias of the data container.
ESTIMATED_NUMBER_OF_ROWS int64 Nombre estimé de lignes Number of rows expected in total, against which the rows loaded read as progress.
FAILURE_COUNT int32 Nombre d'échecs Number of times pre-emptive fetching data failed.
FINISHED_DATE_UTC datetime Date d'achèvement 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 Nombre de pauses Number of times pre-empty loading was paused to leave the capacity to the user.
ROWS_LOADED int64 Nombre de lignes chargées Number of rows brought in so far.
SCHEMA_NAME varchar2(240) Schema Schema of the object.
STARTED_DATE_UTC datetime Date de début 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.

Clés

Key Column Se réfère à Kind Description
SYSTEMPREEMPTIVELOADINGPARTITIONS_CANDIDATE_ID_SYSTEMPREEMPTIVELOADCANDIDATES_fk CANDIDATE_ID 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 :