OraFAQ Forum: Performance Tuning » performance issue oracle 10g RAC

Home » RDBMS Server » Performance Tuning » performance issue oracle 10g RAC (Oracle 10g RAC with ASM Windows Server 2003)

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

performance issue oracle 10g RAC [message #413216]

Tue, 14 July 2009 16:10

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

Report message to a moderator

Re: performance issue oracle 10g RAC [message #413241 is a reply to message #413216]

Tue, 14 July 2009 23:43

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: performance issue oracle 10g RAC [message #413628 is a reply to message #413241]

Thu, 16 July 2009 16:24

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

Report message to a moderator

Re: performance issue oracle 10g RAC [message #413655 is a reply to message #413628]

Thu, 16 July 2009 23:18

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: performance issue oracle 10g RAC [message #413665 is a reply to message #413655]

Fri, 17 July 2009 00:01

marcobain
Messages: 7
Registered: June 2009

Junior Member

I was built to run on oracle rac.

Report message to a moderator

Re: performance issue oracle 10g RAC [message #413666 is a reply to message #413216]

Fri, 17 July 2009 00:05

BlackSwan
Messages: 26766
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.

Report message to a moderator

Re: performance issue oracle 10g RAC [message #413670 is a reply to message #413666]

Fri, 17 July 2009 00:19

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

Report message to a moderator

Re: performance issue oracle 10g RAC [message #413674 is a reply to message #413216]

Fri, 17 July 2009 00:31

BlackSwan
Messages: 26766
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!

Report message to a moderator

Re: performance issue oracle 10g RAC [message #415908 is a reply to message #413628]

Wed, 29 July 2009 14:18

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

Report message to a moderator

Previous Topic:	Rollback segment too small error
Next Topic:	Negative Tablespace Free Space value

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 22 12:42:42 CST 2024