OraFAQ Forum: RAC & Failsafe » RAC some queries

Home » Server Options » RAC & Failsafe » RAC some queries (Oracle 11g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

RAC some queries [message #439891]

Tue, 19 January 2010 22:03

Richard2009
Messages: 21
Registered: October 2009
Location: London

Junior Member

Hi Experts,

what's the advantages of having the different instances or databases on a node in RAC database

Please advise.

Regards,
Richard

Report message to a moderator

Re: RAC some queries [message #439893 is a reply to message #439891]

Tue, 19 January 2010 22:39

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>what's the advantages of having the different instances or databases on a node in RAC database
The same pro & con arguments that apply to a stand alone system for having only 1 or more than 1 DB per system.

There is no 1 size fit all cases solution.
For some situations only 1 DB per system is better.
For some situations more than 1 DB is better.
It is a case by case decision & in some cases the deciding factor is not technical, but budgetary (hardware & license fees).

Report message to a moderator

Re: RAC some queries [message #439985 is a reply to message #439893]

Wed, 20 January 2010 08:02

Richard2009
Messages: 21
Registered: October 2009
Location: London

Junior Member

Hi BlackSwan,

Thanks for your repsonse. Are there any performance improvements if we create a separate instance with an user to retain historical data?

If not, can we create a database on the different server to retain the historical data?

Please shed some lights on this..

Thanks & Regards,
Richard

Report message to a moderator

Re: RAC some queries [message #439992 is a reply to message #439985]

Wed, 20 January 2010 08:18

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

I think we already answered to this question in your previous topic: Need for separate instance in RAC database
If not, tell us in which points.

Regards
Michel

Report message to a moderator

Re: RAC some queries [message #440004 is a reply to message #439985]

Wed, 20 January 2010 09:26

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>Are there any performance improvements if we create a separate instance with an user to retain historical data?
At best with multiple instance, performance will stay the same.
Multiple instance means more overhead which can make things SLOWER.

Report message to a moderator

Re: RAC some queries [message #440054 is a reply to message #440004]

Wed, 20 January 2010 14:36

Richard2009
Messages: 21
Registered: October 2009
Location: London

Junior Member

Thanks Michel & BlackSwan

Report message to a moderator

Previous Topic:	Oracle 10g RAC on RHEL 5 - OCR integrity results are inconsistent
Next Topic:	How to convert RAC database to single Instance Database?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Jan 07 00:07:03 CST 2025