Re: multi oracle instances in one machine

From: David Sisk <davesisk_at_ipass.net>
Date: 1998/12/29
Message-ID: <2UNh2.66$24.319@news.ipass.net>#1/1

Hi:

I would suggest using a single database with multiple schemas. That way, you conserve one machine resources. Unless this is actually the same app for production use, test use, and development use. If that's the case, then I'd suggest three seperate databases.

Hope this helps.

Regards,

--
David C. Sisk
The Unofficial ORACLE on NT site
http://www.ipass.net/~davesisk/oont.htm


bjin wrote in message <368769CB.15B684D8_at_hpsgns1.sgp.hp.com>...


>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

>

Received on Tue Dec 29 1998 - 00:00:00 CST