"Nirupam" <nirupam.newaskar_at_fmr.com> wrote:
>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
No additional impact, per se, by having multiple schemas..Almost ALL Oracle installations are set up that way.
( IN fact, all Oracle installations have at least 2 schemas from the start ( SYS and SYSTEM) )
Received on Thu Nov 03 2005 - 09:13:58 CST
