Re: PARALLEL_MAX_SERVERS value
Date: Wed, 26 Oct 2011 07:09:46 +0000
> But CPUx10 es definitely too many because IMHO a CPU, either thread or core
> should not handle more than 4 requests, 10 is a lot!
FWIW at page 495 of TOP I wrote "...a value of 8-10 times the number of cores (in other words, the value of the initialization parameter cpu_count) is a good starting point".
I generally do not see a problem with such "high" values because:
- Slaves might be allocated to a specific execution but do nothing. - Parallel processing is, generally, I/O bound. Especially with current CPUs you hit the I/O limit way before the system is CPU bound. - Setting parallel_min_percent to values higher than the default (0) is in many cases not an option.
IMO "low" values are only good when you control what's going on and, therefore, you can avoid that there are too many downgrades.
In summary, I generally prefer to have a system where too many slaves are allocated as the opposite. It goes without saying that there are exceptions!
Troubleshooting Oracle Performance, Apress 2008 http://top.antognini.chReceived on Wed Oct 26 2011 - 02:09:46 CDT