Re: Oracle "Instance" same as SQL Server "Database"?

From: Alex Hudghton <alex_at_alenda.freeserve.co.uk>
Date: Tue, 14 Sep 1999 09:28:06 +0100
Message-ID: <7rl0uo$kuf$1@taliesin.netcom.net.uk>

Eric Yu <ericyu_at_NOSPAM.centerprise.com> wrote in message news:hneD3.291$H26.6727_at_client...
> As a newby to Oracle coming from an MS/Sybase SQL Server background, am I
> correct in interpreting that an Oracle Instance is equivalent to a
separate
> Database in SQLServer? Thus, to create a new logical database requires
> creating a new Instance with separate associated processes for each
> instance? Or may it also be appropriate to define & treat a Schema within
> an Instance as (semantically) equivalent to a separate Database (without
the
> associated additional processes)?

Instance = background processes (pmon, smon etc...) and structures in memory (SGA and components)

Database = physical data and control files on disk

In common use, one database and one instance. (can have multiple database / instance on single node)

In parallel server, one database (on shared disk) and multiple instances (usually one per node)

Alex Received on Tue Sep 14 1999 - 03:28:06 CDT