Re: 2-node RAC faster than 6-node!

Thanks for everyone who has replied. I understand it is very hard to make suggestions without a more detailed knowlege of the DB/app/environment. However, I was just trying to see if anyone can help pinpoint us on areas to focus on as possible culprits.   

Thanks again,
  Abdul

Alex Gorbachev <ag_at_oracloid.com> wrote:
  Abdul,

I suspect that things might get even quicker if you leave only one node. Perhaps, it can be your final solution even? You can still run 2 node RAC and direct workload to a single node.

By the way, did you check that connections are actually routed to both nodes and they both active? If you connection load balancing is screwed you might be already running on a single machine and just didn't notice it in the moment of excitement (or disappointment, depending on your perspective).

On the performance tuning... well, I guess it's not easy to summarize it in the email format. You need someone wearing performance analyst hat to look at it. You could start from the Statspack or AWR report to have an initial idea of the workload and possible path of investigation. Alternatively, you could focus on the most important business functions but in your case they might lead you back to the cluster-wide analysis to see what's trashing your system.

Alex

On 2-Apr-08, at 5:40 PM, A Ebadi wrote:

> 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.

--
http://www.freelists.org/webpage/oracle-l




       
---------------------------------
You rock. That's why Blockbuster's offering you one month of Blockbuster Total Access, No Cost.
--
http://www.freelists.org/webpage/oracle-l