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.