Re: Educating developers on RAC
From: Andrew Kerber <andrew.kerber_at_gmail.com>
Date: Tue, 12 Jun 2012 12:53:04 -0500
Message-ID: <CAJvnOJa7WTYNZ3EPdygheCq7AsM4Y-HyE42DkkH5FSWyZ=egwg_at_mail.gmail.com>
by default 11.2.0.x will install with the parallel query options enabled (enterprise edition anyway). there is a parameter parallel_force_local which defaults to false. If this is not set to true, any parallelized query can run on multiple nodes at the same time, and if large can clog your interconnect quickly.
On Tue, Jun 12, 2012 at 12:40 PM, Paul Harrison <cure_at_austin.rr.com> wrote:
Date: Tue, 12 Jun 2012 12:53:04 -0500
Message-ID: <CAJvnOJa7WTYNZ3EPdygheCq7AsM4Y-HyE42DkkH5FSWyZ=egwg_at_mail.gmail.com>
by default 11.2.0.x will install with the parallel query options enabled (enterprise edition anyway). there is a parameter parallel_force_local which defaults to false. If this is not set to true, any parallelized query can run on multiple nodes at the same time, and if large can clog your interconnect quickly.
On Tue, Jun 12, 2012 at 12:40 PM, Paul Harrison <cure_at_austin.rr.com> wrote:
> where you can have the same query running on several nodes <-- What do you
> mean by that exactly?
> <SNIP>
>
-- Andrew W. Kerber 'If at first you dont succeed, dont take up skydiving.' -- http://www.freelists.org/webpage/oracle-lReceived on Tue Jun 12 2012 - 12:53:04 CDT