Search notes:

Oracle: DBA_PARALLEL_EXECUTE_CHUNKS

select
   chk.chunk_id,
   chk.task_owner,
   chk.task_name,
   chk.status,
   chk.start_rowid,
   chk.end_rowid,
   chk.start_id,
   chk.end_id,
   chk.job_name,
   chk.start_ts,
   chk.end_ts,
   chk.error_code,
   chk.error_message,
   --
   tsk.sql_stmt,
   tsk.status,
   tsk.table_owner,
   tsk.table_name
from
   dba_parallel_execute_chunks chk                                         join
   dba_parallel_execute_tasks  tsk on chk.task_owner = tsk.task_owner and
                                      chk.task_name  = tsk.task_name
where
   chk.task_owner = user
order by
   chk.start_ts desc;

See also

dba_parallel_execute_tasks
dmbs_parallel_execute
data dictionary

Index