Re: Oracle RAC Stored Procedure scalability


<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


.

Relevant Pages

  • Oracle RAC Stored Procedure scalability
    ... Just wonder how the oracle rac facilitate the stored procedure ... procedure call on different members of cluster. ...
    (comp.databases.oracle.server)
  • Re: Tracking users when browser is closing
    ... solution was to use an IFrame with an ASP page that I called ... This is a self refreshing page that refreshes every 30 ... The page executes a stored procedure on SQL Server that modifies and ... plugs in the members id and date visited (or updates the record if the ...
    (microsoft.public.inetserver.asp.general)
  • Re: datareader doing updates
    ... On a test we granted Alpha exec rights to an update Stored Procedure. ... members of Alpha are now able to run the Stored Procedure and do updates ...
    (microsoft.public.sqlserver.security)
  • RE: Sql To Active Directory Quickie
    ... list of our groups and their members. ... Is there a way to pull a list of groups and their memebers? ... > Server is it possible to create a stored procedure that will take a username ... > find what active directory groups the user is a member of, ...
    (microsoft.public.sqlserver.programming)
  • How to view #temp tables in vs.net (stored procedures)
    ... When you step into a stored procedure using vs.net, you get all the debug ... members WHERE...). ... Is it possible to view the temp tables? ...
    (microsoft.public.dotnet.framework.aspnet)