Oracle RAC Stored Procedure scalability

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

.

Relevant Pages

  • Re: Oracle RAC Stored Procedure scalability
    ... Just wonder how the oracle rac facilitate the stored procedure ... stored procedure scalability is dependent upon whether it was well ...
    (comp.databases.oracle.server)
  • Re: 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: Clustered Index question
    ... If you cluster just on ... I'd still keep the primary key. ... Columnist, SQL Server Professional ... the database is the ones in the Stored Procedure, ...
    (microsoft.public.sqlserver.programming)
  • Re: Oracle RAC Stored Procedure scalability
    ... Just wonder how the oracle rac facilitate the stored procedure ... procedure call on different members of cluster. ... separate network is needed for RAC ...
    (comp.databases.oracle.server)
Loading