Fwd: Parallel queries in RAC environment
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-lReceived on Wed Oct 15 2008 - 10:09:12 CDT