RE: Number of parallel process and parallel_max_servers

Sami

>Anytime we look at the number of parallel process, 
>it is close to 50. Since we have  8 CPUs and
>parallel_threads_per_cpu=2, Is there any advantage
>of having more than 16 parallel process?

As a rule of thumb I'm used to start with a value between 2 and 4 times the 
number of CPU. The optimal setting depends on how much your parallel operations 
are CPU and/or IO bound. Therefore, IMO, 100 is too much. 


Regards,
Chris

New Features Oracle Database 10g Release 2 seminars @ www.trivadis.com
Italiano: Lugano (24-Nov)
Français: Genève (17-Nov)
Deutsch: Zürich (11-Oct), Hamburg (13-Oct), München (20-Oct), Basel (25-Oct), 
         Frankfurt (27-Oct), Bern (8-Nov), Düsseldorf (23-Nov), Stuttgart 
(13-Dec)
--
http://www.freelists.org/webpage/oracle-l

Other related posts: