Re: Question about instances

An Oracle Instance consists of the Background Processes like LGWR,DBWR etc and Datablock buffer Cache,Redo loguffer Cache,Shared Pool etc which are basically Memory buffers allocated by OS for the Oracle Server.

A Database mounts to the Instance during the Startup and the Instance acquires a Database lock over the associated Datafiles( Unless Parallel Server where multiple Instances can mount the Same Database).

So Both Database Instance & Server Instance refer to the Same,if at all if these terms are technically used.

Also Pls Understand that More than One Oracle Server(Instance) can run on the Same Server(Host ).

A Database can have Multiple Schemas(Set of Database Objects like Tables,Indexes,Procedures etc) each associated with a Database User.

Hope this Clarifies U'r Doubts...

-Thiru

sergey_s_at_my-deja.com wrote:

> I am a bit confused about server/database instances.
> Is server instance the same as database instance? In
> the book I am reading the two wordings seem to refer
> to the same thing sometimes and two different things
> at other times.
>
> So far, I tend to beleive that there is a server
> instance within which I can have one or more schemas.
> Is that correct?
>
> Thanks for help in advance!
>
> Sergey
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
Received on Wed Jun 23 1999 - 15:24:01 CDT