Forum Stats

  • 3,824,769 Users
  • 2,260,416 Discussions
  • 7,896,309 Comments

Discussions

TASK are not assign to process in DBMS_PARALLEL_EXECUTION

Kumarnkl
Kumarnkl Member Posts: 12 Red Ribbon

Using DBMS_PARALLEL_EXECUTION, We are updating the huge number of records.

Previously it was working in parallel execution. But now while execute the parallel execution script. It create the TASK and chunks divided based on size but not assigning the chunks to process. IN the user_parallel_execute_tasks table showing as CHUNKED status. Please assist me on this issue?

In the user_parallel_execute_chunks table status all in UNASSIGNED. Since all task are not process.

Tagged: