Oracle RAC Stored Procedure scalability

From: <waihunglo_at_gmail.com>
Date: 2 Aug 2006 20:44:10 -0700
Message-ID: <1154576650.248074.68310@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 Received on Wed Aug 02 2006 - 22:44:10 CDT