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?

Brian, 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?

If you are using Oracle 10g, then you can use Grid Control to locate your performance bottlenecks. Point your browser to your Grid Control and click on the Performance tab. The charts will show you were your performance is at its worst. If you have configured your browser with the SVG plug-in (there is a link on the Performance page to download this plug-in), you can even drill down in your worst trouble areas.

Otherwise, the first thing to check is to ensure that your cluster interconnect is configured correctly and that...

Step 2 of 2:

You forgot to provide an Email Address.

This email address doesn’t appear to be valid.

This email address is already registered. Please login.

You have exceeded the maximum character limit.

Please provide a Corporate E-mail Address.
- I agree to TechTarget’s Terms of Use, Privacy Policy, and the transfer of my information to the United States for processing to provide me with relevant information as described in our Privacy Policy.
Please check the box if you want to proceed.
- I agree to my information being processed by TechTarget and its Partners to contact me via phone, email, or other means regarding information relevant to my professional interests. I may unsubscribe at any time.
Please check the box if you want to proceed.

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.

This was last published in August 2006

Dig Deeper on Oracle database design and architecture

All
News
Get Started
Evaluate
Manage
Problem Solve

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

SearchDataManagement

Related Resources

Dig Deeper on Oracle database design and architecture

Have a question for an expert?

Start the conversation

0 comments

Register

Login

Forgot your password?

Your password has been sent to:

Please create a username to comment.