Re: 11g RAC parallel queries

From: hrishy <hrishys_at_yahoo.co.uk>
Date: Wed, 15 Jul 2009 05:48:58 +0000 (GMT)
Message-ID: <430043.52547.qm_at_web23703.mail.ird.yahoo.com>

Hi Greg
 
Thanks for the explanation I appreciate very much  
regards
Hrishy

• On Wed, 15/7/09, Greg Rahn <greg_at_structureddata.org> wrote:

From: Greg Rahn <greg_at_structureddata.org> Subject: Re: 11g RAC parallel queries
To: hrishys_at_yahoo.co.uk
Cc: oracle-l_at_freelists.org
Date: Wednesday, 15 July, 2009, 6:32 AM

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-l

Received on Wed Jul 15 2009 - 00:48:58 CDT