Re: How to setup RAC to avoid Inter-Instance Parallelism
Date: Wed, 10 Jun 2009 18:28:55 +0200
Message-ID: <8580d4110906100928u5a4fb394h562e3632a9489ce2_at_mail.gmail.com>
Why is the parallell slaves on different instances a problem. I think you need to understand why that causes a problem in order to devise a solution. What happens if you log on to just one of the nodes instead of to the cluster?
WHat is the main wait event?
Mathias
On Wed, Jun 10, 2009 at 6:10 PM, GBA-DBA <gba.oraclel_at_gmail.com> wrote:
> 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-lReceived on Wed Jun 10 2009 - 11:28:55 CDT