Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Number of parallel process and parallel_max_servers

RE: Number of parallel process and parallel_max_servers

From: Christian Antognini <Christian.Antognini_at_trivadis.com>
Date: Wed, 28 Sep 2005 19:16:16 +0200
Message-ID: <F2C9CCA71510B442AF71446CAE8AEBAF13442D@MSXVS04.trivadis.com>


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
Received on Wed Sep 28 2005 - 12:18:22 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US