Looking for pointers in troubleshooting -> RAC performance degradation (single instance is fine)

From: Pradeep Chetal <Pradeep.Chetal_at_mformation.com>
Date: Thu, 24 Dec 2009 08:28:51 -0500
Message-ID: <4BF4B618B11C2140B597AA57A1551A84DF82E1_at_mfusemail01.mformation.com>


 

Folks,  

We have an app that is running well in single instance but when put on a 2-node or 3-node RAC, we see pretty much similar performance. However, if the CPU time is 55-60% in single instance, it becomes 20% in 3-node RAC and top-5 itmed events become..  

"gc buffer busy", "gc current block busy", "enq: TX- index contention  

Any help in what to look for will be greatly appreciated.  

Thanks,  

  • Pradeep

Pradeep Chetal
Sr. Director - Infrastructure Architecture

Mformation Technologies Inc.
Switchboard: +1 732 692 6200  

Visit WWW.MFORMATION.COM and see how the MFORMATION SERVICE MANAGER can help you to transform your business

Please consider the environment before printing

This message and the information contained herein is proprietary and confidential and subject to the Mformation Confidentiality policy statement, you may request a copy by emailing info_at_mformation.com



--
http://www.freelists.org/webpage/oracle-l
Received on Thu Dec 24 2009 - 07:28:51 CST

Original text of this message