Re: when do I use multiple instances ?

Nikko,

First Oracle is very specific about its use of the word's instance and database.

Using one set of Oracle executables (installation), you can create any number databases (limited only by the system's memory and disk), these are identified uniquely by the Oracle 'sid'.

An instance is a term used when discussing Oracle Parallel server, in this case a single database (held on a shared disk layout) can be accessed by other nodes in a cluster (UNIX, Vax or otherwise) where the disk is shared and the memory/cpu are independent. In this case, you would have one instance/node connecting to the single, shared database.

Parallel server is used for scalability and resiliency and is limited to clusters and MPP boxes.

Hope this helps

Nick

nikko wrote in message <37188C28.FB1B4AA_at_po.jaring.my>...
>Why and when do one use multiple instances in Oracle ? Can two different
>instance communicate(exchange data?)
>
>Thank you.
>
Received on Sat Apr 17 1999 - 19:51:12 CDT