invantive documentation
Invantive SupportforenAnmelden / Eintragen

SYSTEMPREEMPTIVELOADINGPARTITIONS: Data Dictionary Pre-emptive Loading Partitions

read only

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

Es können nur Daten abgerufen werden.

Tabellenspalten

Die Spalten der Tabelle SYSTEMPREEMPTIVELOADINGPARTITIONS sind unten aufgeführt. Jede Spalte hat einen SQL-Datentyp. Beim Einfügen und Aktualisieren muss für jede erforderliche Spalte jederzeit ein neuer Wert angegeben werden der nicht Null ist.

Name Datentyp Label Required Marks Documentation
BYTES_PROCESSED int64 Geschriebene Bytes Number of bytes received and written to the local caches on its behalf.
CALLS_SPENT int64 Getätigte Anrufe Number of calls to the platform spent on it so far.
CANDIDATE_ID int64 Candidate Identity of the candidate this work belongs to.Siehe SystemPreemptiveLoadCandidates.
CATALOG_NAME varchar2(240) Catalog Catalog of the object.
DATA_CONTAINER_ALIAS varchar2(240) Datencontaineralias Alias of the data container.
ESTIMATED_NUMBER_OF_ROWS int64 Geschätzte Reihenanzahl Number of rows expected in total, against which the rows loaded read as progress.
FAILURE_COUNT int32 Anzahl der Fehler Number of times pre-emptive fetching data failed.
FINISHED_DATE_UTC datetime Fertigstellungsdatum 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 Anzahl der Pausen Number of times pre-empty loading was paused to leave the capacity to the user.
ROWS_LOADED int64 Geladene Zeilen Number of rows brought in so far.
SCHEMA_NAME varchar2(240) Schema Schema of the object.
STARTED_DATE_UTC datetime Startdatum 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.

Tasten

Key Column Bezieht sich auf Kind Description
SYSTEMPREEMPTIVELOADINGPARTITIONS_CANDIDATE_ID_SYSTEMPREEMPTIVELOADCANDIDATES_fk CANDIDATE_ID SYSTEMPREEMPTIVELOADCANDIDATES.ID Key

Anmerkungen zu dieser Version

Was hat sich in den Tabellen, Spalten, Attributen und Funktionen des Treibers mit jeder neuen Version geändert: