Number of parallel process and parallel_max_servers

From: Sami Seerangan <dba.orcl_at_gmail.com>
Date: Wed, 28 Sep 2005 09:28:52 -0700
Message-ID: <f09dd62805092809286386a94@mail.gmail.com>

Hi,

We have 8 CPUs on each node (Sun-Fire-V490 - 3 Node RAC) Oracle 9.2.0.6 <http://9.2.0.6>, Sun OS 2.9

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?
We defined the "parallel_max_servers=100", is it the right value of 8 CPU machine?

$ ps -ef|grep p0|wc -l
48

SQL> show parameter parallel

NAME TYPE VALUE

------------------------------------ -----------
------------------------------

fast_start_parallel_rollback string LOW
log_parallelism integer 1

parallel_adaptive_multi_user boolean TRUE
parallel_automatic_tuning boolean TRUE
parallel_execution_message_size integer 4096
parallel_instance_group string
parallel_max_servers integer 100
parallel_min_percent integer 0
parallel_min_servers integer 0
parallel_server boolean TRUE
parallel_server_instances integer 3
parallel_threads_per_cpu integer 2
recovery_parallelism integer 0

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Sep 28 2005 - 11:31:09 CDT