Re: New Instance

> In parallel server systems a
> single database can mount multiple instances.

Wouldn't it be -
"In parallel server systems, one database is mounted and opened by multiple instances concurrently"?

• from Oracle Parallel Processing (O'Reilly) - pg 97

A little difference between who is doing the mounting :)

Paul

Van Messner wrote:
>
> When a database is started (nomount) on a database server Oracle allocates a
> memory area called the System Global Area or SGA and starts one or more
> Oracle processes. The combination of the SGA and these processes is called
> an instance.
> After starting an instance Oracle mounts a database (a set of data files)
> to the instance. Multiple instances, each accessing its own physical
> database can be run on the same computer. In parallel server systems a
> single database can mount multiple instances.
>
> "James Chappell" <james_at_rees-chappell.demon.co.uk> wrote in message
> news:XBrahhAJToK7EwnE_at_rees-chappell.demon.co.uk...
> > I'm always confused between an "Instance" and a "Database".
> > Don't you have one database, and one or more instances, or is it the
> > other way round?
> >
> > In article <NKcW6.389$Tt6.128756_at_monger.newsread.com>, Van Messner
> > <vmessner_at_bestweb.net> writes
> > >I hesitate to even mention it in this group but you can also run the
 ((low
> > >whisper) database creation assistant) and have a lot of the drudge work
 done
> > >for you.
> > >
> > >Van
> > >
> > >
> > >"James Chappell" <james_at_rees-chappell.demon.co.uk> wrote in message
> > >news:YnW54KAyW+J7Ew9M_at_rees-chappell.demon.co.uk...
> > >> How do I create a second instance on my NT box? I'm running Oracle
 8.0.6
> > >> at the moment.
> > >>
> > >> Thanks in advance for help.
> > >>
> > >> --
> > >> James Chappell
> > >
> > >
> >
> > --
> > James Chappell
Received on Sat Jun 16 2001 - 14:12:56 CDT