Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Parallel Application Processing
Billy wrote:
> Mladen Gogala wrote:
>
>
>>>Does this method make sense? Are there better methods to consider? >> >>Partitioning it by hash (or range, if you can do that) and then acessing >>different partitions in parallel would seem like the perfect way.
If you have "Effective by Design", Tom Kyte describes a possible solution to your problem using rowids and a number of jobs for parallel processing.
It is also briefly covered here:
http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:10498431232211
However, running 100's of them in parallel would mean you need to have the horse power to do so. According to Cary Milsap (read Batch Queue discipline and Batch Queue and the magic of 2 available at hotsos.com after registration) you shouldn't run more jobs than 2 times the number of CPUs in parallel. But if you have such a beast (with SE? noway) you'll be fine, else you'll just set job_queue_processes accordingly.
Regards,
Holger
Received on Mon Aug 08 2005 - 08:14:12 CDT
![]() |
![]() |