Re: Maximum Oracle instances on a Server?

I agree with every comment everyone made. But with respect to the money issue ... I strongly suggest that everyone go to eBay and put in the following search criterion:

"Sun Server" where right now there is a SUN Netra T1 105 Server for $1099 and a Enterprise 3000 with 4 CPUs and 4GB RAM for $8900. What company can't afford this?
or
"HP 9000" where right now there is a K machine with 2GB RAM, 2x4GB disks, 8x4GB disks, etc. fpr $4800. Or how about an L-1000 enterprise rack server for $7500?

Sure they're not completely built out. But the parts are available and they are not exactly scrap metal.

If you need more servers ... think creatively. Two weeks ago I got an Sun Ultra 5 and an HP 9000 C machine, all for less than $1000 including shipping. And either could be used for a department-level instance supporting 10-20 users.

Daniel Morgan

Ganesh Raja wrote:

> 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 - 11:17:04 CST