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