Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Parallel Application Processing
Billy wrote:
> Holger Baer wrote:
>
>
[...]
>
>>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.
That goes without saying. But the point is, that in a typical batch environment CPU and disk usage aproximately level out, so while one process is using CPU the other one is waiting for disk. And I talked *specifically* about batch processing, which means the processes are actually doing something - not some threads that are just hanging around. :-)
As for the scalability of this solution: You just have to break it up into enough pieces, set the job_queue_processes accordingly and Bob's your uncle.
Cheers
Holger
Received on Wed Aug 10 2005 - 04:43:06 CDT
![]() |
![]() |