Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

performance issue

902663Feb 21 2012 — edited Feb 23 2012
Hello,

we have 2 environments ; RAC 4 nodes database, 11.2.0.2.5 under redhat linux 5.5 and RAC 2 nodes database, 11.2.0.2.5 under redhat linux 5.5.

Developers are comlaining that an insert statement error (primary key already esists) is returned after 15 seconds in the 4 nodes RAC where it is only returns 1 second in the RAC 2 nodes.

they are testing exactly the same insert statement, and same version of the application.

I would like to know ; How to troubleshoot the problem?

thank you,
Diego
This post has been answered by orawiss on Feb 23 2012
Jump to Answer

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 22 2012
Added on Feb 21 2012
9 comments
118 views