OraFAQ Forum: RAC & Failsafe » What are the impact of RAC on the PL/SQL programming

Home » Server Options » RAC & Failsafe » What are the impact of RAC on the PL/SQL programming (10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

What are the impact of RAC on the PL/SQL programming [message #408418]

Tue, 16 June 2009 03:06

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

Report message to a moderator

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

babuknb
Messages: 1734
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

Report message to a moderator

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

ebrian
Messages: 2794
Registered: April 2006

Senior Member

Check the RAC Admin Guide (Additional Considerations and Features for Oracle Real Application Clusters).

Report message to a moderator

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

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.

Report message to a moderator

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

farenheiit
Messages: 31
Registered: June 2009
Location: Paris

Member

No more ideas about my requirement?

Report message to a moderator

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

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)

Report message to a moderator