VIEW: SYS.DBA_PARALLEL_EXECUTE_CHUNKS

Source

View Text - Preformatted

select c.CHUNK_ID,
       u.username,
       c.TASK_NAME,
       decode( c.status, 0, 'UNASSIGNED',
                         1, 'ASSIGNED',
                         2, 'PROCESSED',
                         3, 'PROCESSED_WITH_ERROR' ),
       c.START_ROWID,
       c.END_ROWID,
       c.START_ID,
       c.END_ID,
       c.JOB_NAME,
       c.START_TS,
       c.END_TS,
       c.ERROR_CODE,
       c.ERROR_MESSAGE
from DBMS_PARALLEL_EXECUTE_CHUNKS$ c,
     DBA_USERS                     u
where task_owner# = u.user_id

View Text - HTML Formatted

SELECT C.CHUNK_ID
, U.USERNAME
, C.TASK_NAME
, DECODE( C.STATUS
, 0
, 'UNASSIGNED'
, 1
, 'ASSIGNED'
, 2
, 'PROCESSED'
, 3
, 'PROCESSED_WITH_ERROR' )
, C.START_ROWID
, C.END_ROWID
, C.START_ID
, C.END_ID
, C.JOB_NAME
, C.START_TS
, C.END_TS
, C.ERROR_CODE
, C.ERROR_MESSAGE FROM DBMS_PARALLEL_EXECUTE_CHUNKS$ C
, DBA_USERS U WHERE TASK_OWNER# = U.USER_ID