| 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
|
|
|
|
|
|
|
|
| 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.
|
|
|
|
|
|
| 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)
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
