Skip Headers
Oracle® Database Reference
11g Release 2 (11.2)

Part Number E10820-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

DBA_PARALLEL_EXECUTE_CHUNKS

DBA_PARALLEL_EXECUTE_CHUNKS displays all tasks in the database.

Related View

USER_PARALLEL_EXECUTE_CHUNKS displays the 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:
  • UNASSIGNED

  • ASSIGNED

  • PROCESSED

  • PROCESSED_WITH_ERROR

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