Re: Impact of two databases sharing an oracle instance

From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Thu, 3 Nov 2005 06:00:31 -0500
Message-ID: <NfOdnUCbYZNPcPTenZ2dnUVZ_tCdnZ2d@comcast.com>

"Nirupam" <nirupam.newaskar_at_fmr.com> wrote in message news:1131002225.268852.39330_at_g44g2000cwa.googlegroups.com...
> 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
>
> Regards
> Nirupam
>

strongly suggest you study the Oracle Concepts manual (http://tahiti.oracle.com), as you are confusing schema, instance and database concepts

it seems likely, however, that you simply need two schemas (accounts) in a single database.

++ mcs Received on Thu Nov 03 2005 - 05:00:31 CST