VIEW: SYS.DBA_PARALLEL_EXECUTE_TASKS

Source

View Text - Preformatted

select u.username,
       t.task_name,
       decode( t.chunk_type, -1, 'UNDECLARED',
                              0, 'ROWID_RANGE',
                              1, 'NUMBER_RANGE'),
       decode( dbms_parallel_execute_internal.task_status(t.task_owner#,
                                                          t.task_name),
               1, 'CREATED',
               2, 'CHUNKING',
               3, 'CHUNKING_FAILED',
               4, 'NO_CHUNKS',
               5, 'CHUNKED',
               6, 'PROCESSING',
               7, 'FINISHED',
               8, 'FINISHED_WITH_ERROR',
               9, 'CRASHED' ),
       t.TABLE_OWNER,
       t.TABLE_NAME,
       t.NUMBER_COLUMN,
       t.CMT,
       t.JOB_PREFIX,
       t.SQL_STMT,
       t.LANGUAGE_FLAG,
       t.EDITION,
       t.APPLY_CROSSEDITION_TRIGGER,
       t.FIRE_APPLY_TRIGGER,
       t.PARALLEL_LEVEL,
       t.JOB_CLASS
from DBMS_PARALLEL_EXECUTE_TASK$ t,
     DBA_USERS                   u
where task_owner# = u.user_id

View Text - HTML Formatted

SELECT U.USERNAME
, T.TASK_NAME
, DECODE( T.CHUNK_TYPE
, -1
, 'UNDECLARED'
, 0
, 'ROWID_RANGE'
, 1
, 'NUMBER_RANGE')
, DECODE( DBMS_PARALLEL_EXECUTE_INTERNAL.TASK_STATUS(T.TASK_OWNER#
, T.TASK_NAME)
, 1
, 'CREATED'
, 2
, 'CHUNKING'
, 3
, 'CHUNKING_FAILED'
, 4
, 'NO_CHUNKS'
, 5
, 'CHUNKED'
, 6
, 'PROCESSING'
, 7
, 'FINISHED'
, 8
, 'FINISHED_WITH_ERROR'
, 9
, 'CRASHED' )
, T.TABLE_OWNER
, T.TABLE_NAME
, T.NUMBER_COLUMN
, T.CMT
, T.JOB_PREFIX
, T.SQL_STMT
, T.LANGUAGE_FLAG
, T.EDITION
, T.APPLY_CROSSEDITION_TRIGGER
, T.FIRE_APPLY_TRIGGER
, T.PARALLEL_LEVEL
, T.JOB_CLASS FROM DBMS_PARALLEL_EXECUTE_TASK$ T
, DBA_USERS U WHERE TASK_OWNER# = U.USER_ID