RE: 2node/3node RAC
- From: "Steve Kirby" <kirby@xxxxxxxxxxxxxxxxxxx>
- To: "'k srinivas'" <k.sridba@xxxxxxxxx>, <ora-apps-dba@xxxxxxxxxxxxx>
- Date: Mon, 20 Jun 2011 23:55:18 -0700
For performance I would pick a single DB server for the same processors/RAM.
RAC has some performance overhead. Not much, but some. Under 10g I had
some difficult to diagnose performance problems, but those seem to have gone
away under 11.
For scalability RAC is the way to go ... throw servers at the problem and
you can scale until the cows come home
For reliability I lean toward a single server since, in my experience, RAC
is harder to maintain and , at least under 10g, I found a couple of bugs I
never saw under single server.
For manageability single server beats RAC hands down. Fewer DBA's are
exposed to RAC and there are just more steps to everything. It is also
pretty easy to break a RAC by updating configuration files incorrectly.
2 node v 3 node. I don't really see the difference. You have all the
headaches of RAC once you get second server involved. From a licensing and
manageability I would stick with fewer nodes ... with 1 being ideal. The
only question I would have is how can you get the greatest amount of RAM and
CPU to Oracle... If you can do it in 2 servers ... use 2. If you need 3
servers ...go 3.
Steve
_____
From: k srinivas [mailto:k.sridba@xxxxxxxxx]
Sent: Monday, June 20, 2011 11:26 PM
To: ora-apps-dba@xxxxxxxxxxxxx; kirby@xxxxxxxxxxxxxxxxxxx
Subject: Re: 2node/3node RAC
Hi Steve,
I have already put a question ...I want to know is it better to go for 3node
or 2node RAC keeping in my mind
scalability and performance.
On Sun, Jun 19, 2011 at 6:44 AM, Steve Kirby <kirby@xxxxxxxxxxxxxxxxxxx>
wrote:
Is there a question you want to ask?
Steve
_____
From: ora-apps-dba-bounce@xxxxxxxxxxxxx
[mailto:ora-apps-dba-bounce@xxxxxxxxxxxxx] On Behalf Of k srinivas
Sent: Saturday, June 18, 2011 12:49 AM
To: ora-apps-dba
Subject: 2node/3node RAC
Hi All,
We are on EBS 11.5.10.2 and on 10G RAC having 2 db nodes.
We are planning to migrate to 3 node RAC .I have 1 doubt for scalability and
performance wise is it better to have
2 node or 3 node RAC,Keeping in point our Prod OLTP DB size is 8TB .
Thanks in advance ..
Other related posts:
