Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: two databases in a server

RE: two databases in a server

From: <oracle-l-bounce_at_freelists.org>
Date: Thu, 30 Mar 2006 13:04:00 -0600
Message-ID: <FB5D3CCFCECC2948B5DCF4CABDBE669754601B@QTEX1.qg.com>


We do have several applications that share an instance, but that's because those apps generally are related (e.g. data from one app schema needed in another). But I don't see any benefit of merging unrelated apps with distinctly different data and access methods (e.g. data entry vs. DSS/query vs. automated data collection). I'd think off-hand that it would make that one monolithic instance much more difficult to manage than several smaller ones (shared_pool flogging comes to mind).

And I think the need to migrate the apps to another instance for app-specific version upgrades has already been mentioned.

My $.02,
Rich

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Ric Van Dyke Sent: Thursday, March 30, 2006 12:05 PM
To: tom_at_tafox.com; David Sharples
Cc: Oracle-L_at_Freelists. Org (E-mail)
Subject: RE: two databases in a server

Generally it's bad because there is a certain level of resource consumption for an instance of any size. So pay the price ONCE and have an instance large enough to do all the work needed by all the applications using the database. There can be cases where multiple instances on the same box are needed, but many cases that I have seen it was not needed. Many times folks can use one instance (or at least fewer instances) to get the work done.

Ric Van Dyke
Hotsos Enterprises



Hotsos Symposium, be there:
http://www.hotsos.com/portal/events/SYM06

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Tom Fox Sent: Thursday, March 30, 2006 12:53 PM
To: David Sharples
Cc: roger_xu_at_dp7uptx.com; Oracle-L_at_Freelists. Org (E-mail) Subject: Re: two databases in a server

I've heard the argument before about having more than one instance on a machine is a bad idea.

However, on the flip side, having 50 applications share one instance can

be bad, as if one app needs a particular patch, you're affecting 49 other
applications due to one application's requirements.

Anyone care to elaborate why more than one instance is bad?

--Tom

On Thu, 30 Mar 2006, David Sharples wrote:

> by joining them into a single instance - that is best practise
>

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


--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Mar 30 2006 - 13:04:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US