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