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@xxxxxxxxxxxxxxx> 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 -- //www.freelists.org/webpage/oracle-l