RE: Parallel slave on the other nodes - RAC

  • From: <Ravi_Kulkarni@xxxxxxxx>
  • To: <shivaswamykr@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 3 May 2007 11:37:30 -0500

This is normal behaviour. If you dont like this or is causing issues for
your App, please look at documenation on using INSTANCE_GROUPS
INSTANCE_GROUPS is a Real Application Clusters parameter that you can
specify only in parallel mode. 
Used in conjunction with the PARALLEL_INSTANCE_GROUP parameter, it lets
you restrict parallel query operations to a limited number of instances.


From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Shivaswamy Raghunath
Sent: Thursday, May 03, 2007 10:38 AM
To: Oracle-L Freelists
Subject: Parallel slave on the other nodes - RAC


I am on Redhat Linux. 3 Node RAC.

I am using a service to connect to the instance thru sqlplusw. This
service is not-TAF Enabled. So no pre-connect nothing. When I make a
connection to any of the instances, I see parallel processes/slaves on
the other two nodes/instances to which I have not connected. On the
other node the process looks like "ora_pz99_* ". I have tried to
research this. I have not got much info. But I don't have a clue why
this is happening. The parallel parameters are (in case of interest): 
NAME                                        VALUE    
-----------------------------------         --------
parallel_adaptive_multi_user               TRUE    
parallel_automatic_tuning                   FALSE    
parallel_execution_message_size       4096    
parallel_max_servers                          160     
parallel_min_percent                           0       
parallel_min_servers                           12       
parallel_server                                    TRUE    
parallel_server_instances                     3       
parallel_threads_per_cpu                      2       

Any insight is appreciated.


Other related posts: