Running a batch in parallel
391484Nov 18 2004 — edited Nov 18 2004I am currently having issues with our batch over-running and various jobs failing due to contention issues. I was therefore about to investigate the use of some sort of parallel processing (we are currently running version 8.1.7.4.1 of the database) to alleviate these problems. However, I'm not sure it will help too much. Most of our batch runs the same common code (packages etc. held on the database), which accesses the same tables (but for different key values). Will any degree of parallelism still give us the same issues, as we are running the same code and accessing the same tables?
Anybody got any ideas?