Fwd: Parallel queries in RAC environment
- From: "Stefan Knecht" <knecht.stefan@xxxxxxxxx>
- To: oracle-l <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 15 Oct 2008 17:09:12 +0200
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@xxxxxxxxx> 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
>
> --
> //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@xxxxxxxxxxxxxxxxxxx
http://www.opitz-consulting.ch
OCP 9i/10g SCSA SCNA
=========================
Other related posts:
- » Fwd: Parallel queries in RAC environment
