select tsk.task_owner, tsk.task_name, tsk.chunk_type, tsk.parallel_level, tsk.sql_stmt, tsk.status, tsk.table_owner, tsk.table_name, tsk.number_column, tsk.task_comment, tsk.job_prefix, tsk.language_flag, tsk.edition, tsk.apply_crossedition_trigger, tsk.fire_apply_trigger, tsk.job_class from dba_parallel_execute_tasks tsk where tsk.task_owner = user;