Fwd: Parallel queries in RAC environment
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.
On Wed, Oct 15, 2008 at 3:09 PM, Martin Klier <usn_at_usn-it.de> wrote:
> 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?
> Martin Klier
> Usn's IT Blog for Linux, Oracle, Asterisk
-- ========================= 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