Home » Server Options » RAC & Failsafe » Plsql Programming Guidelines within a RAC Environment (Oracle 10g, Linux)
Plsql Programming Guidelines within a RAC Environment [message #401622] Tue, 05 May 2009 18:22 Go to next message
efachim
Messages: 42
Registered: July 2008
Member
Hi Guys,

Are there any specific guidelines you would recommend for programming within a RAC environment, in addition to the usual best practices one would adopt for writing Plsql programs? ie guidelines that would take advantage of the performance boost from the high availability feature of the RAC environment, as well as the processing power?
Re: Plsql Programming Guidelines within a RAC Environment [message #401623 is a reply to message #401622] Tue, 05 May 2009 18:30 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Contrary to what you imagine, PL/SQL is not self-aware & will never know or care whether or not it is running on a RAC.
No special coding is required for RAC.

>guidelines that would take advantage of the performance boost
There will be NO "performance boost".
At best performance will stay the same.
More than likely a slight performance degradation will occur due to RAC overhead.
Re: Plsql Programming Guidelines within a RAC Environment [message #401624 is a reply to message #401622] Tue, 05 May 2009 18:32 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>take advantage of the performance boost from the high availability feature of the RAC environment

RAC just provides High Availability (node level) and load balancing.
It has nothing to do with performance.
With respect to performance, it will work the same way as a single instance.

Previous Topic: URGENT -CRS-0184: Cannot communicate with the CRS daemon.
Next Topic: PRECONNECT and SELECT behavior ?
Goto Forum:
  


Current Time: Thu Mar 28 19:32:03 CDT 2024