Re: when do I use multiple instances ?

From: Pete Sharman <psharman_at_us.oracle.com>
Date: Mon, 19 Apr 1999 09:18:57 -0700
Message-ID: <371B5771.7FA5E690@us.oracle.com>

It's always better to separate these databases (DEV, TEST, PROD) on separate machines if you can. In particular keep development off the same machine as Production. Developers are very heavy resource users, and take resources away from the Production users if they're not separated.

Pete

v tsien wrote:

> Nikko,
> If you have only one server and want to run a developer version, a qa test
> version, and a production version of the database on the same machine you
> can set up thre different instances on the same machine. Or if you want to
> seperate your applications based on their charactistics (say, OLTP and DSS)
> you can put them on different instances so that you can set the parameters
> differently (in initsid.ora and configsid.ora).
> You can exchange data among the instance through database link or
> replication.
> nikko <nikko_at_po.jaring.my> wrote in message
> news:37188C28.FB1B4AA_at_po.jaring.my...
> > Why and when do one use multiple instances in Oracle ? Can two different
> > instance communicate(exchange data?)
> >
> > Thank you.
> >

Regards

Pete

Peter Sharman                             Email: psharman_at_us.oracle.com
WISE Course Development Manager           Phone: +1.650.607.0109 (int'l)
Worldwide Internal Services Education            (650)607 0109 (local)

San Francisco

SQL> select standard_disclaimer, witty_remark 2 from company_requirements;

Opinions are mine and do not necessarily reflect those of Oracle Corporation

"Controlling application developers is like herding cats." Kevin Loney, ORACLE DBA Handbook
"Oh no it's not! It's much harder than that!" Bruce Pihlamae, long term ORACLE DBA

Received on Mon Apr 19 1999 - 11:18:57 CDT