DBA_PARALLEL_EXECUTE_CHUNKS

I was not able to find this anywhere so therefore this comment.

As sys I created some chunks using:

DBMS_PARALLEL_EXECUTE.CREATE_CHUNKS_BY_SQL

I expected that the job would be visible in DBA_PARALLEL_EXECUTE_CHUNKS for other users also. This is almost the case.

However ORACLE has decided that only the creator of the task can see start_rowid, end_rowid, start_id and end_id. This is due to the follwing in the view definition of DBA_PARALLEL_EXECUTE_CHUNKS:

    case when userenv('SCHEMAID') = c.task_owner# or userenv('SCHEMAID') = 0

     then c.START_ROWID

     else null