Re: instances and databases

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sun, 27 Jun 1999 23:50:41 +0200
Message-ID: <930520184.27904.0.pluto.d4ee154e@news.demon.nl>

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 Jun 27 1999 - 16:50:41 CDT