invantive documentation
Invantive Support ForumsAanmelden / Inschrijven

SYSTEMPREEMPTIVELOADINGPARTITIONS: Data Dictionary Pre-emptive Loading Partitions

read only

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

Kan alleen gegevens ophalen.

Tabelkolommen

De kolommen van de tabel SYSTEMPREEMPTIVELOADINGPARTITIONS worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype. Voor elke vereiste kolom moet bij het invoegen en bijwerken steeds een nieuwe, niet-lege waarde worden opgegeven.

Name Datatype Label Required Marks Documentation
BYTES_PROCESSED int64 Aantal geschreven bytes Number of bytes received and written to the local caches on its behalf.
CALLS_SPENT int64 Gespreksduur Number of calls to the platform spent on it so far.
CANDIDATE_ID int64 Candidate Identity of the candidate this work belongs to.Zie SystemPreemptiveLoadCandidates.
CATALOG_NAME varchar2(240) Catalog Catalog of the object.
DATA_CONTAINER_ALIAS varchar2(240) Datacontainer Alias Alias of the data container.
ESTIMATED_NUMBER_OF_ROWS int64 Geschat Aantal Rijen Number of rows expected in total, against which the rows loaded read as progress.
FAILURE_COUNT int32 Aantal Mislukkingen Number of times pre-emptive fetching data failed.
FINISHED_DATE_UTC datetime Voltooid op 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 Aantal Pauzes Number of times pre-empty loading was paused to leave the capacity to the user.
ROWS_LOADED int64 Rijen Geladen 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.

Toetsen

Key Column Verwijst naar Kind Description
SYSTEMPREEMPTIVELOADINGPARTITIONS_CANDIDATE_ID_SYSTEMPREEMPTIVELOADCANDIDATES_fk CANDIDATE_ID SYSTEMPREEMPTIVELOADCANDIDATES.ID Key

Release Notes

Wat is er per release veranderd in de tabellen, kolommen, attributen en mogelijkheden van de driver: