Re: Two databases/SIDs on same NT box

i would first like to thank you for posting to the newsgroups and to my email. Makes it much easier to know when you get an answer.

Now I understand. I'm on my first project running oracle. Thank you for enlightening me.

Andrew Babb wrote:

> 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 Tue Apr 27 1999 - 20:20:15 CDT