Re: 11g RAC parallel queries
From: Greg Rahn <greg_at_structureddata.org>
Date: Tue, 14 Jul 2009 22:32:03 -0700
Message-ID: <a9c093440907142232s6f8f8952v35608b78eb0676c3_at_mail.gmail.com>
11g services do replace the instance_groups/parallel_instance_group parameters. You define which nodes the service runs on, and which instances it includes.
Date: Tue, 14 Jul 2009 22:32:03 -0700
Message-ID: <a9c093440907142232s6f8f8952v35608b78eb0676c3_at_mail.gmail.com>
11g services do replace the instance_groups/parallel_instance_group parameters. You define which nodes the service runs on, and which instances it includes.
So yes, you can define a 1 node, 1 instance service to limit PX to that node.
For example:
srvctl add service -d <db name> -s <service name> -r <instance list>
On Tue, Jul 14, 2009 at 10:10 PM, hrishy<hrishys_at_yahoo.co.uk> wrote:
> Hi
>
> I came across a statement from a fellow DBA saying parallel queries now run
> acording to service placement does this mean that if i have a services
> called dw on node 1 only that parallel queries qould not spawn on other
> nodes ?
>
> regards
> Hrishy
>
-- Regards, Greg Rahn http://structureddata.org -- http://www.freelists.org/webpage/oracle-lReceived on Wed Jul 15 2009 - 00:32:03 CDT