Re: How to setup RAC to avoid Inter-Instance Parallelism

From: Greg Rahn <>
Date: Wed, 10 Jun 2009 11:00:46 -0700
Message-ID: <>

This will not prevent parallel query slaves from spanning instances. Without instance_groups/parallel_instance_group (or services in 11g), a single PQ statement can still span instances.

On Wed, Jun 10, 2009 at 10:02 AM, QuijadaReina, Julio C<> wrote:
> For a quick test you could set up connect identifier for instance 1 on your
> tnsnames.ora and point it to IP/name of that one node. Set the environment
> to that identifier and run your query. You may need to set up a separate
> listener service with the name of the connect identifier on the server node.
> If your query goes to just one node and the behavior persists, there may be
> some node interconnect issues.

Greg Rahn
Received on Wed Jun 10 2009 - 13:00:46 CDT

Original text of this message