Re: Two databases/SIDs on same NT box

Multiple Instances allows different configurations, you may have one application requiring Mission Critical 7x24 OLTP, and another requiring 6x18 Data Warehouse and a third which is for Development running 5x8. All of these have different SLA's. If you merge into a single Instance then the configuration would not allow easy restoration of a Development database without impacting the OLTP system.

Just some suggestions, there are many more Andrew

John Seitz wrote:

> what is the advantage of having two instances of Oracle?
>
> John
>
> Alexander G Bozhik wrote:
>
> > Hi,
> > I used to have some (two - three at least) databases, running at the same
> > time on my NT server.
> > In fact these databases have different SIDs and different SGAs. I guess
> > the only thing they share is listener.
> >
> > SY,
> > Alexander G Bozhik.
> >
> > Peter Laursen wrote in message <01be8fc2$5fcefa60$2c289a0a_at_apollo>...
> > >Hello all
> > >
> > >Is it possible to have two databases, with different SIDs, running at the
> > >same time on a NT box?
> > >
> > >Will they share SGA, or will there be two SGAs?
> > >
> > >Thanks
> > >Peter
> > >
Received on Mon Apr 26 1999 - 21:25:11 CDT