Number of parallel process and parallel_max_servers
- From: Sami Seerangan <dba.orcl@xxxxxxxxx>
- To: oracle-l <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 28 Sep 2005 09:28:52 -0700
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
Other related posts:
