Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle RAC Stored Procedure scalability
<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 Received on Wed Aug 02 2006 - 22:50:22 CDT