2

I'm running a procedure in parallel by using oracle's dbms parallel execute utility which chunks the workload ; but I have few chunks failing and I can't see any error logs. Is there a way to find out ?

Jon Heller
  • 34,999
  • 6
  • 74
  • 132
UserOp
  • 174
  • 7

1 Answers1

2

Check this. The last two columns. 

   SELECT *
        FROM   user_parallel_execute_chunks
        WHERE  task_name = '{task name}'
        ORDER BY chunk_id
    /

I'm not sure, but probably you can use job_name from previous table. And query for more information from scheduler's tables. user_scheduler_job_run_details, user_scheduler_job_log.

Arkadiusz Łukasiewicz
  • 6,241
  • 1
  • 11
  • 17