Re: Impact of two databases sharing an oracle instance

Sorry guys I didn't put my question correclty.

As of now I have two seperate databases (DB1, which is Oracle 8.1.7.4 & DB2, which is Orcale 8.1.7.2) on a single Solaris box. Lets assume that DB1 has schema S1 and DB2 has schema S2

now we want to move to a new Solaris box which has a single database instacne (9i) and put both S1 & S2 in it (i.e. an oracle database with two schemas, right?)

what will be the impact on performance, capacity? what areas should we consider to avoid any issues?

Regards
Nirupam

Mark C. Stock wrote:
> "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 - 06:53:01 CST