Re: Oracle RAC Stored Procedure scalability

From: HansF <Fuzzy.Greybeard_at_gmail.com>
Date: Thu, 03 Aug 2006 04:07:44 GMT
Message-Id: <pan.2006.08.03.04.10.09.466553@gmail.com>

On Wed, 02 Aug 2006 20:50:22 -0700, Jim Kennedy wrote:

> 
> <waihunglo_at_gmail.com> wrote in message
> news:1154576650.248074.68310_at_75g2000cwc.googlegroups.com...

>> Hi all,
>>
>> Just wonder how the oracle rac facilitate the stored procedure
>> scalability issue? Any experience that we can share. Does the oracle
>> run the stored procedure on a single member of cluster? Is there any
>> way that make the stored procedure horizontally scale?
>>
>> I guess one of the possible way is to partition data and issue stored
>> procedure call on different members of cluster. Does it induce the
>> network overhead in order to synchronized the table content across the
>> members of the cluster.
>>
>> Thanks in advance.
>> Ivan Lo
>>

> 
> The different members of the cluster all access the same disk.  So if the
> sql statements can scale horizontillay then the stored proc can
> Jim

In support of that, if the SQL statement can take advantage of parallelism on an SMP box, it can also take advantage of RAC.

The network traffic concern is somewhat valid until you realize that a separate network (including separate network cards) is needed for RAC interconnect purposes anyway.

The question implies some holes in basic understanding of RAC architecture. As that is too large a topic to review in a newsgroup, I'd suggest it's time to hit the RAC concepts books (again).

-- 
Hans Forbrich   (mailto: Fuzzy.GreyBeard_at_gmail.com)   
*** Feel free to correct me when I'm wrong!
*** Top posting [replies] guarantees I won't respond.

Received on Wed Aug 02 2006 - 23:07:44 CDT