Re: How to setup RAC to avoid Inter-Instance Parallelism
Date: Wed, 10 Jun 2009 11:00:46 -0700
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
> 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.
-- Regards, Greg Rahn http://structureddata.org -- http://www.freelists.org/webpage/oracle-lReceived on Wed Jun 10 2009 - 13:00:46 CDT