Home » Server Options » RAC & Failsafe » What are the impact of RAC on the PL/SQL programming (10g)
What are the impact of RAC on the PL/SQL programming [message #408418] Tue, 16 June 2009 03:06 Go to next message
farenheiit
Messages: 31
Registered: June 2009
Location: Paris
Member
Hi,

Currently in my company, our application is running with one instance.
We want to implement RAC and I'd like to know whate are the possible impacts on the PL/SQL code. For example I was told about the working of sequences which can be disturbed.

Does someone has already studied these impacts?
Is there a web page on this subject ?

thanks for helping
Re: What are the impact of RAC on the PL/SQL programming [message #408453 is a reply to message #408418] Tue, 16 June 2009 04:59 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member


>>We want to implement RAC and I'd like to know whate are the possible impacts on the PL/SQL code. For example I was told about the working of sequences which can be disturbed

disturbed ??

>>Does someone has already studied these impacts?

What impact ??

>Is there a web page on this subject ?

NOT able to understand your question. What exactly your requirement? Why you want implement RAC?

Babu
Re: What are the impact of RAC on the PL/SQL programming [message #408455 is a reply to message #408418] Tue, 16 June 2009 05:15 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Check the RAC Admin Guide (Additional Considerations and Features for Oracle Real Application Clusters).
Re: What are the impact of RAC on the PL/SQL programming [message #408460 is a reply to message #408453] Tue, 16 June 2009 05:29 Go to previous messageGo to next message
farenheiit
Messages: 31
Registered: June 2009
Location: Paris
Member
Sorry if you didn't understand my requirement, i'm french and my english is not very good.

I'm working for a financial software editor. Our product is used by several clients in the world. Some clients would like to implement RAC on their Database and I have to ensure that our product will be compatible with RAC environnement. That's why i'd want to know what are generally the consequences of implementing RAC.
Re: What are the impact of RAC on the PL/SQL programming [message #408752 is a reply to message #408460] Wed, 17 June 2009 10:55 Go to previous messageGo to next message
farenheiit
Messages: 31
Registered: June 2009
Location: Paris
Member
No more ideas about my requirement?
Re: What are the impact of RAC on the PL/SQL programming [message #409736 is a reply to message #408752] Tue, 23 June 2009 14:54 Go to previous messageGo to next message
asangapradeep
Messages: 128
Registered: October 2005
Location: UK
Senior Member
Quote:
For example I was told about the working of sequences which can be disturbed.
Ordered sequences will have an impact on the RAC.

All in all if your application scale well in a single instance you can be pretty sure RAC will also scale it.

But if you have bottlenecks in single instance then these will not go away just because RAC is implemented. (might even get worse)

The prominent impact would be cost, (more hardware, software license cost and etc)
Re: What are the impact of RAC on the PL/SQL programming [message #409737 is a reply to message #408418] Tue, 23 June 2009 14:56 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>Ordered sequences
What other kinds of sequences are there?

Re: What are the impact of RAC on the PL/SQL programming [message #409739 is a reply to message #409737] Tue, 23 June 2009 15:28 Go to previous messageGo to next message
asangapradeep
Messages: 128
Registered: October 2005
Location: UK
Senior Member
read here
Re: What are the impact of RAC on the PL/SQL programming [message #409745 is a reply to message #409736] Tue, 23 June 2009 19:00 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
asangapradeep wrote on Tue, 23 June 2009 15:54

But if you have bottlenecks in single instance then these will not go away just because RAC is implemented. (might even get worse

A better way of saying this would be...might get better, might get worse or might not change.
Previous Topic: RAC on vmware server/virtual PC
Next Topic: SAN storage Migration using ASM
Goto Forum:
  


Current Time: Thu Mar 28 08:35:56 CDT 2024