Fwd: Parallel queries in RAC environment

From: Stefan Knecht <knecht.stefan_at_gmail.com>
Date: Wed, 15 Oct 2008 17:09:12 +0200
Message-ID: <486b2b610810150809t5e39c53cg199fd29029bdf7d5@mail.gmail.com>


In 11g Oracle has changed the default behaviour on this:

If you don't set parallel_instance_groups parameter, and connect to the SERVICE, Oracle will start all parallel slave processes on the current instance.

Cheers

Stefan

On Wed, Oct 15, 2008 at 3:09 PM, Martin Klier <usn_at_usn-it.de> wrote:

> Hi,
>
> James Barton schrieb:
> > How can I force all of the child query processes to be on the same
> > instance as the parent process?
>
> What a shame that the optimizer (CBO) does not recognize RAC properly in
> 10g. Has anybody experience if this kind of situations are avoided in 11g?
>
> Regards
> Martin Klier
> --
> Usn's IT Blog for Linux, Oracle, Asterisk
> http://www.usn-it.de
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
=========================

Stefan P Knecht
Senior Consultant
Systems Engineering

OPITZ CONSULTING Schweiz GmbH
Seestrasse 97
CH-8800 Thalwil

Mobile +41-79-571 36 27
stefan.knecht_at_opitz-consulting.ch
http://www.opitz-consulting.ch

OCP 9i/10g SCSA SCNA
=========================

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Oct 15 2008 - 10:09:12 CDT

Original text of this message