Bad application performance on Oracle RAC
We are deploying a new vendor-supplied application. It has never been tested or deployed in a RAC environment. We are deploying on a RAC environment. We are seeing some serious performance issues. Are there any specific checks to see if the deployment on RAC is the reason for the bad performance?
Otherwise, the first thing to check is to ensure that your cluster interconnect is configured correctly and that...
Continue Reading This Article
Enjoy this article as well as all of our content, including E-Guides, news, tips and more.
there is no other traffic on this interconnect. The interconnect should be a private network that only lets one node see any other node in the cluster. The interconnect should not be used for anything else as this can cause performance problems.
If the interconnect is configured correctly, and you still cannot determine where your bottlenecks lie, you can query GV$SYSTEM_EVENT to see the top wait events causing your performance problems. For the most part, working with wait events in RAC is just like working with wait events in a single-node environment.
Dig Deeper on Oracle database design and architecture
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.
Meet all of our Oracle Database / Applications experts
View all Oracle Database / Applications questions and answers
Start the conversation
0 comments