Home » RDBMS Server » Performance Tuning » performance issue oracle 10g RAC (Oracle 10g RAC with ASM Windows Server 2003)
performance issue oracle 10g RAC [message #413216] Tue, 14 July 2009 16:10 Go to next message
marcobain
Messages: 7
Registered: June 2009
Junior Member
Hello everyone,

Pls advice on the performance issue I have with Oracle 10g RAC. We have run a stress test on the 2 Nodes RAC DB and is hanging at 3000 transactions per minute. But when we try to run the same number of transactions on a standalone 10g DB it went well. We even got higher up to 5000. What could be the problem on the Oracle RAC setup. Both RAC DB and Stand alone DB is connected to EMC Storage.

Thanks in advance,
marcobain
Re: performance issue oracle 10g RAC [message #413241 is a reply to message #413216] Tue, 14 July 2009 23:43 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The problem is most likely that your application is not built to run on RAC.

Run AWR/Statspack and/or search for interconnect statistics and hot blocks.

Regards
Michel
Re: performance issue oracle 10g RAC [message #413628 is a reply to message #413241] Thu, 16 July 2009 16:24 Go to previous messageGo to next message
marcobain
Messages: 7
Registered: June 2009
Junior Member
thank you for the response.. I am sure my application can run on RAC but I thing I noticed was when I shutdown one nodes the performance gets better and acceptable. Once do you think is the problem? can you advice on how I can tune the private connection, I am using a gigabit switch and configured a VLAN.

Regards,
Marco
Re: performance issue oracle 10g RAC [message #413655 is a reply to message #413628] Thu, 16 July 2009 23:18 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
"run" does not mean "build for".
If it is not "nuild for" RAC, it is not unusual that performances with 2 or more nodes are less than with 1 node.

Before searching any hardware issue, search for application one.

Regards
Michel
Re: performance issue oracle 10g RAC [message #413665 is a reply to message #413655] Fri, 17 July 2009 00:01 Go to previous messageGo to next message
marcobain
Messages: 7
Registered: June 2009
Junior Member
I was built to run on oracle rac.

Re: performance issue oracle 10g RAC [message #413666 is a reply to message #413216] Fri, 17 July 2009 00:05 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
>I was built to run on oracle rac.
Errors occur.
Errors of omission and/or errors of commission.
Applications on RAC scale poorly when inter-connect traffic is required.
Data accessed on 1 node is required to remain on that node.
Application should not share or exchange data between nodes.
Re: performance issue oracle 10g RAC [message #413670 is a reply to message #413666] Fri, 17 July 2009 00:19 Go to previous messageGo to next message
marcobain
Messages: 7
Registered: June 2009
Junior Member
Are you saying that I should disable the load balancing? If yes, should I disable it on the client or the server side?

Thank you,
marcobain
Re: performance issue oracle 10g RAC [message #413674 is a reply to message #413216] Fri, 17 July 2009 00:31 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
Applications on RAC scale poorly when inter-connect traffic is required.
Application should not share or exchange data between nodes.

I am 100% convinced that the 2 statements above are true.
If your load balancing results in inter-node traffic, then it could be part of the problem.

I do know that RAC applications keep data on on single node, run as well as non-RAC applications.

When applications on RAC have performance degrade it results from increase in inter-node traffic.

It is your call!
Re: performance issue oracle 10g RAC [message #415908 is a reply to message #413628] Wed, 29 July 2009 14:18 Go to previous message
t.velayutham@gmail.com
Messages: 1
Registered: July 2009
Location: CHENNAI
Junior Member
Dear Marco,

Kindly check the interconnectivy between nodes. If it is two node cluster, you can use high giga bytes cross cable for inter node connection , instead of switch.

Regards,
T.Velayutham
Previous Topic: Rollback segment too small error
Next Topic: Negative Tablespace Free Space value
Goto Forum:
  


Current Time: Sat Dec 10 10:50:00 CST 2016

Total time taken to generate the page: 0.19744 seconds