Re: New Instance

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 Fri Jun 15 2001 - 19:47:30 CDT