Re: Meaning of an INSTANCE.

Nabil Courdy wrote:
>
> I am having trouble with the meaning of an instance. If
> I have a very busy production machine, does it make sense
> to have more than one instance? What I am trying to say is,
> for each database, say: payroll, manufacturing, and hr,
> do I have to have three instances, or somehow I create
> all three databases into one instance? Because, if I have
> to have three instances, that seems like a lot of processes
> running to service them.

  More than one instance or not depends on your design. Anyway, one database can be shared by more than one instance which is called Parallel Option. However, if you have three instances, it is certain that more resources are allocated to the Oracle.

  Related Topics: Distributed Database, Parallel Database, SGA, Shared Memory

-- 
Name        : Lun Wing San
Title       : Senior Consultant of Lun's Oracle Solution Company
Email Addr. : sunny_at_hkpc.org
Telephone   : 852-2788-5841