invantive documentation
Invantive Support ForumsLog In / Sign Up

SYSTEMPREEMPTIVELOADINGPARTITIONS: Data Dictionary Pre-emptive Loading Partitions

read only

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

Can only retrieve data.

Table Columns

The columns of the table SYSTEMPREEMPTIVELOADINGPARTITIONS are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

Name Data Type Label Required Marks Documentation
BYTES_PROCESSED int64 Bytes Written Number of bytes received and written to the local caches on its behalf.
CALLS_SPENT int64 Calls Spent Number of calls to the platform spent on it so far.
CANDIDATE_ID int64 Candidate Identity of the candidate this work belongs to. See SystemPreemptiveLoadCandidates.
CATALOG_NAME varchar2(240) Catalog Catalog of the object.
DATA_CONTAINER_ALIAS varchar2(240) Data Container Alias Alias of the data container.
ESTIMATED_NUMBER_OF_ROWS int64 Estimated Number of Rows Number of rows expected in total, against which the rows loaded read as progress.
FAILURE_COUNT int32 Number of Failures Number of times pre-emptive fetching data failed.
FINISHED_DATE_UTC datetime Finished Date 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 Number of Pauses Number of times pre-empty loading was paused to leave the capacity to the user.
ROWS_LOADED int64 Rows Loaded Number of rows brought in so far.
SCHEMA_NAME varchar2(240) Schema Schema of the object.
STARTED_DATE_UTC datetime Started Date 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.

Keys

Key Column Refers to Kind Description
SYSTEMPREEMPTIVELOADINGPARTITIONS_CANDIDATE_ID_SYSTEMPREEMPTIVELOADCANDIDATES_fk CANDIDATE_ID SYSTEMPREEMPTIVELOADCANDIDATES.ID Key

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: