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

E40402-08
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
PDF · Mobi · ePub

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(30) 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(30)   Owner of the table to be chunked
TABLE_NAME VARCHAR2(30)   Name of the table to be chunked
NUMBER_COLUMN VARCHAR2(30)   Name of the column holding IDs (only applicable to NUMBER_RANGE chunking type)
TASK_COMMENT VARCHAR2(4000)   Comment field
JOB_PREFIX VARCHAR2(30)   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(30)   Argument used in the previous DBMS_PARALLEL_EXECUTE.RUN_TASK
APPLY_CROSSEDITION_TRIGGER VARCHAR2(30)   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(30)   Argument used in the previous DBMS_PARALLEL_EXECUTE.RUN_TASK