Re: multi oracle instances in one machine

From: RP Data Solutions <rpdata_at_cyberus.ca>
Date: Mon, 28 Dec 1998 16:23:13 GMT
Message-ID: <3687af99.576156088@news.cyberus.ca>

Stick with one instance, but be sure to distribute your IO. Maitaining 3 instances will become a real pain(backups, recovery, tuning, etc....).. Also give the 1 instance a healthy SGA, rollback, & temp and you'll be fine....

Cheers,

bjin <jinbo_at_hpsgns1.sgp.hp.com> wrote:

>Hi,
>
>Kindly give me some guidelines on this.
>
>Within our product framework, there are 3 sub-applications which use
>Oracle database to store data. Each of them owns a set of tables
>respectively. These 3 applications run on a single machine.
>
>When implementing system, we have two choices.
>1. Create only 1 Oracle database and create tables of 3 applications in
>3 different user's schema.
>2. Create 3 Oracle databases in 1 machine and create tables in 3
>different databases.
>
>Which way is better? What should we consider when choosing from the 2
>methods?
>
>The platform is hp9000, hpux 10.x and Oracle 7.3.4. It has 1G memory and
>4 cpus.
>
>Thanks
>
>bjin
>

Robert Prendin
RP Data Solutions Inc.
Specializing in ORACLE DBA Support Services Received on Mon Dec 28 1998 - 10:23:13 CST