Re: instances and databases

The other instance doesn't have to reside on another machine. It really depends on the DLM that you use.

Anjo.

Sybrand Bakker wrote:

> Hi Richar
> The first statement is true.
> Multiple instances can access one database in parallel server situations.
> The instances need to reside on different systems, and the disks be shared.
> A maxinstance > 1 when you are not running parallel server, doesn't make
> sense.
>
> Hth,
>
> Sybrand Bakker, Oracle DBA
>
> <java_mensch_at_my-deja.com> wrote in message
> news:7l652p$v6u$1_at_nnrp1.deja.com...
> > Hi,
> >
> > I'm confused about the distinction between databases
> > and instances.
> >
> > I reckon an Instance is a group of processes which
> > access the physical storage (the database).
> >
> > The CREATE DATABASE statements has a parameter
> > MAXINSTANCES which presumably means I can
> > have more than one instance per database. Does a
> > value > 1 make any sense if I am not running parallel
> > server ?
> >
> > Thanks,
> > Richar Sullivan
> >
> >
> > Sent via Deja.com http://www.deja.com/
> > Share what you know. Learn what you don't.
Received on Sun Jul 11 1999 - 03:30:30 CDT