Re: Maximum Oracle instances on a Server?

From: Ganesh Raja <ganesh_at_gtfs-gulf.com>
Date: Wed, 27 Feb 2002 12:06:24 +0400
Message-ID: <a5i44i$3lj4@news-dxb.emirates.net.ae>

You will be running two Databases on this Machine which is going to be a overkill if u'r Memory Requirments are not met ...

The better way to go baout doing this would be to use a Different PFILE for u'r OLAP Dbs and a Differnet One for your OLTP DBs...

U can start u'r instance as required using these pfiles...

this wil work unless u dont have a 24x7 shop.

HTH

--
[Additions and Corrections Welcome.]
Regards,
Ganesh R

"Murali" <oraclems_at_hotmail.com> wrote in message
news:22e6597b.0202261854.4d098ac8_at_posting.google.com...


> damorgan <dan.morgan_at_ci.seattle.wa.us> wrote in message but I've never

understood


> > the reason for creating another instance with its own SGA when you can

just as


> > easily create another schema with its own tablespaces.

>

> Creating schemas is easy. Try maintaining it. What if I have ONE

> machine(no money for 2; it happens), but need two databases, one for

> OLTP that gets used a lot during the day and one DSS that is used only

> at night to run reporting jobs. I would create two different instances

> only because each instance would have its own (and different) tuning

> considerations and it is much easier to run both optimally if I dont

> have them in the same database as different schemas.  I dont want to

> tune the db for my DSS schema to find out next morning that my OLTP

> schema is all screwed up.

>

> As for the original post, like you said, it depends on what you're

> doing and how big (memory and space) each db will be.

>

> Murali

> http://www.dbaquest.com/

Received on Wed Feb 27 2002 - 02:06:24 CST