Re: Impact of two databases sharing an oracle instance

On 2005-11-03, Nirupam <nirupam.newaskar_at_fmr.com> wrote:
> What is the difference in following two approaches -
>
> 1) Two databases having separate oracle instance (hence separate
> schema) on the same Solaris machine
>
> 2) Two databases sharing an instance but having separate schema on a
> Solaris machine
>
> What am trying to figure out is the impact on performance, capacity
> when two databases share the same oracle instance.
>
> Following are the potential areas which would be shared if two
> databases share an instance
>
> 1) System Global Area (SGA)
> 2) Oracle Background processes
> 3) System tablespace
> 4) Temporary tablespace
> 5) Rollback tablespace
> 6) Index tablespace
> 7) Data Tablespace
> 8) SQL*Net driver and other tools
> 9) Archives/Backups
> 10) Query processor

Based on your vagueness, I'd recommend to put all schemas in one database. I have yet to come accross a situation that warrants two instances on the same server.

Rene

-- 
  Rene Nyffenegger
  http://www.adp-gmbh.ch/