How to setup RAC to avoid Inter-Instance Parallelism

From: GBA-DBA <gba.oraclel_at_gmail.com>
Date: Wed, 10 Jun 2009 11:10:38 -0500
Message-ID: <d7e2170906100910q39149d8eg2a83ab2a075c4b87_at_mail.gmail.com>



Hello list,

I have a two node 10.1.0.5 RAC setup

serv1 - instance 1
serv2 - instance 2

We are using parallel query for batch processing. The time to complete batch is ok when we run in a non clustered environment (that's what we have in dev and integrated testing) but when we move the batch to a clustered testing environment similar to prod everything takes 2 or 3 times longer.

I have noticed that some of the slave processes go to instance 1 and some of them go to instance 2. I would like to confine the parallel slaves to one instance but I don't fully understand how to setup the instance_groups and parallel_instance_groups to achieve this.

Could anyone help me please?

Thanks in advance.

--

Regards
GBA
--

http://www.freelists.org/webpage/oracle-l Received on Wed Jun 10 2009 - 11:10:38 CDT

Original text of this message