RE: Parallel slave on the other nodes - RAC

Shiva,
 
This is normal behaviour. If you dont like this or is causing issues for
your App, please look at documenation on using INSTANCE_GROUPS
&PARALLEL_INSTANCE_GROUP 
 
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.
 
 
 
Thanks,
Ravi.

________________________________

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


Hello.

I am on Redhat Linux. 3 Node RAC. 10.2.0.2.

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_instance_group                     
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.

Thanks,
Shiva


Other related posts: