Re: Oracle RAC Stored Procedure scalability

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


<waihunglo@xxxxxxxxx> wrote in message
news:1154576650.248074.68310@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
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.

.

Relevant Pages

  • Re: RAC or Large SMP...?
    ... Its exactly this area of RAC that concerns me. ... The resulting trace/log file from the cluster will normally be the ... RAC configuration because a lot of the 'nasties' are handled to a large ... to take advantage of multiple cores can be quite limited. ...
    (comp.databases.oracle.server)
  • Re: RAC or Large SMP...?
    ... The resulting trace/log file from the cluster will normally be the ... As to Oracle trouble shooting I’m not so worried. ... Has the Oracle clusteware and RAC become mature enough so that the ... Oracle homes to patch. ...
    (comp.databases.oracle.server)
  • Re: Upgrade Plan
    ... ASM then it is to copy files to and from a file system. ... I wouldn't throw away those licenses, ... We eventually ditched RAC and are now completing a hpux to linux ... My earlier point is that from a technical standpoint you would have a very difficult time convincing me that using both VCS with CRS in a 10/11g RAC cluster is the right thing to do. ...
    (comp.databases.oracle.server)
  • Re: HP tops 1 million tpmC on Superdome with Itanium2 CPUs
    ... Robert Klute wrote: ... > This may be true for the 'other' cluster benchmarks, ... > Oracle RAC being able to scale. ...
    (comp.os.vms)
  • Re: RAC Cluster Waits
    ... I have a 10.2 RAC with 3 nodes. ... We are seeing what may be "excessive" cluster waits. ... This was a CPU intensive system in the 9i, non-RAC environment, I ... much more expensive then a single instance local locks. ...
    (comp.databases.oracle.server)
Loading