5.221 DBA_PARALLEL_EXECUTE_CHUNKS

DBA_PARALLEL_EXECUTE_CHUNKS displays the chunks for all tasks in the database.

Related View

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(128)

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(128)

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