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_ |
int64 |
Byte scritti | Number of bytes received and written to the local caches on its behalf. | ||
CALLS_ |
int64 |
Chiamate effettuate | Number of calls to the platform spent on it so far. | ||
CANDIDATE_ |
int64 |
Candidate | Identity of the candidate this work belongs to.Vedere SystemPreemptiveLoadCandidates. | ||
CATALOG_ |
varchar2 |
Catalog | Catalog of the object. | ||
DATA_ |
varchar2 |
Alias del contenitore di dati | Alias of the data container. | ||
ESTIMATED_ |
int64 |
Numero stimato di righe | Number of rows expected in total, against which the rows loaded read as progress. | ||
FAILURE_ |
int32 |
Numero di errori | Number of times pre-emptive fetching data failed. | ||
FINISHED_ |
datetime |
Data di completamento | Moment the work reached an end (UTC), or empty while it may still run. | ||
LAST_ |
varchar2 |
Reason | Reason last waited for, dropped or given up. | ||
PARTITION_ |
varchar2 |
Partition | Partition being fetched, or empty for an object which has no partitions. | ||
PAUSE_ |
int32 |
Numero di pause | Number of times pre-empty loading was paused to leave the capacity to the user. | ||
ROWS_ |
int64 |
Righe caricate | Number of rows brought in so far. | ||
SCHEMA_ |
varchar2 |
Schema | Schema of the object. | ||
STARTED_ |
datetime |
Data di inizio | Moment the work started for the first time (UTC), or empty when it never ran. | ||
STATE |
varchar2 |
State | Where it stands: 'Offered', 'Scheduled', 'Running', 'Paused', 'Deferred', 'Done', 'Dropped' or 'Abandoned'. | ||
TABLE_ |
varchar2 |
Table | Name of the table, table function or view. |
Chiavi
| Key | Column | Si riferisce a | Kind | Description |
|---|---|---|---|---|
SYSTEMPREEMPTIVELOADINGPARTITIONS_ |
CANDIDATE_ |
SYSTEMPREEMPTIVELOADCANDIDATES.ID |
Key |
Note di rilascio
Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver: