Re: 2-node RAC faster than 6-node!
- From: A Ebadi <ebadi01@xxxxxxxxx>
- To: ag@xxxxxxxxxxxx
- Date: Wed, 2 Apr 2008 22:46:57 -0700 (PDT)
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@xxxxxxxxxxxx> 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.
--
//www.freelists.org/webpage/oracle-l
---------------------------------
You rock. That's why Blockbuster's offering you one month of Blockbuster Total
Access, No Cost.
Other related posts:
