performance issue
902663Feb 21 2012 — edited Feb 23 2012Hello,
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