Oracle® Database Reference 11g Release 2 (11.2) Part Number E25513-03 |
|
|
PDF · Mobi · ePub |
DBA_PARALLEL_EXECUTE_CHUNKS
displays the chunks for all tasks in the database.
USER_PARALLEL_EXECUTE_CHUNKS
displays the chunks for tasks created by the current user. This view does not display the TASK_OWNER
column.
Column | Datatype | NULL | Description |
---|---|---|---|
CHUNK_ID |
NUMBER |
NOT NULL |
Unique ID for the chunk |
TASK_OWNER |
VARCHAR2(30) |
NOT NULL |
Owner of the task |
TASK_NAME |
VARCHAR2(128) |
NOT NULL |
Name of the task |
STATUS |
VARCHAR2(20) |
Status of the chunk:
|
|
START_ROWID |
ROWID |
Rowid for the first row in the chunk | |
END_ROWID |
ROWID |
Rowid for the last row in the chunk | |
START_ID |
NUMBER |
Number column value of the first row in the chunk | |
END_ID |
NUMBER |
Number column value of the last row in the chunk | |
JOB_NAME |
VARCHAR2(30) |
Name of the job which processed this chunk | |
START_TS |
TIMESTAMP(6) |
Processing start time for the chunk | |
END_TS |
TIMESTAMP(6) |
Processing end time for the chunk | |
ERROR_CODE |
NUMBER |
Error code returned during the execution of the chunk if the STATUS column is PROCESSED_WITH_ERROR |
|
ERROR_MESSAGE |
VARCHAR2(4000) |
Error message returned during the execution of the chunk if the STATUS column is PROCESSED_WITH_ERROR |
See Also:
"USER_PARALLEL_EXECUTE_CHUNKS"