5.226 DBA_PARALLEL_EXECUTE_TASKS

DBA_PARALLEL_EXECUTE_TASKS displays all tasks in the database.

Related View

USER_PARALLEL_EXECUTE_TASKS displays the tasks created by the current user. This view does not display the TASK_OWNER column.

Column Datatype NULL Description

TASK_OWNER

VARCHAR2(128)

NOT NULL

Owner of the task

TASK_NAME

VARCHAR2(128)

NOT NULL

Name of the task

CHUNK_TYPE

VARCHAR2(12)

Type of parallel update:

  • UNDELARED

  • ROWID_RANGE

  • NUMBER_RANGE

STATUS

VARCHAR2(19)

Status of the task:

  • CREATED

  • CHUNKING

  • CHUNKING_FAILED

  • CHUNKED

  • PROCESSING

  • FINISHED

  • FINISHED_WITH_ERROR

  • CRASHED

TABLE_OWNER

VARCHAR2(128)

Owner of the table to be chunked

TABLE_NAME

VARCHAR2(128)

Name of the table to be chunked

NUMBER_COLUMN

VARCHAR2(128)

Name of the column holding IDs (only applicable to NUMBER_RANGE chunking type)

TASK_COMMENT

VARCHAR2(4000)

Comment field

JOB_PREFIX

VARCHAR2(128)

Prefix of the job name executing this task

SQL_STMT

CLOB

Argument used in the previous DBMS_PARALLEL_EXECUTE.RUN_TASK

LANGUAGE_FLAG

NUMBER

Argument used in the previous DBMS_PARALLEL_EXECUTE.RUN_TASK

EDITION

VARCHAR2(130)

Argument used in the previous DBMS_PARALLEL_EXECUTE.RUN_TASK

APPLY_CROSSEDITION_TRIGGER

VARCHAR2(130)

Argument used in the previous DBMS_PARALLEL_EXECUTE.RUN_TASK

FIRE_APPLY_TRIGGER

VARCHAR2(10)

Argument used in the previous DBMS_PARALLEL_EXECUTE.RUN_TASK

PARALLEL_LEVEL

NUMBER

Argument used in the previous DBMS_PARALLEL_EXECUTE.RUN_TASK

JOB_CLASS

VARCHAR2(128)

Argument used in the previous DBMS_PARALLEL_EXECUTE.RUN_TASK

See Also: