- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 62 Insurance
- 536K On-Premises Infrastructure
- 138.2K Analytics Software
- 38.6K Application Development Software
- 5.7K Cloud Platform
- 109.4K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71.1K Infrastructure Software
- 105.2K Integration
- 41.5K Security Software
TASK are not assign to process in DBMS_PARALLEL_EXECUTION
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.