2-node RAC faster than 6-node!
Date: Wed, 2 Apr 2008 14:40:39 -0700 (PDT)
We have an existing 4-node RAC cluster (v440's on Solaris & Oracle 10.2 w/ ASM) that was big time CPU-bound and application performance was suffering. We added 2 new nodes(M5000's) to bring the total to 6 and the app performance actually went down significantly! After messing around with it we found out that by taking the original 4 nodes out of the picture & only running on the 2 new M5000's nodes things improved significantly - the app jobs started running in some cases 20X faster than ever! We tested adding just a single node (v440) back in the mix and performance went way down immediately, so we decided to keep things running on just the 2 M5000's for now.
Any suggestions on identifying root cause as to why the adding of any nodes back to the picture slows things way down? We have an SR opened with Oracle Support but nothing firm so far.
You rock. That's why Blockbuster's offering you one month of Blockbuster Total Access, No Cost.
http://www.freelists.org/webpage/oracle-l Received on Wed Apr 02 2008 - 16:40:39 CDT