Re: Impact of two databases sharing an oracle instance

"Nirupam" <nirupam.newaskar@xxxxxxx> 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@xxxxxxx> wrote in message
>> news:1131002225.268852.39330@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
>> > 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) )


.

Relevant Pages

  • Re: Impact of two databases sharing an oracle instance
    ... which is Orcale 8.1.7.2) on a single Solaris box. ... now we want to move to a new Solaris box which has a single database ... >> schema) on the same Solaris machine ... >> 4) Temporary tablespace ...
    (comp.databases.oracle.server)
  • Re: Rebuilding the system schema
    ... a way to rebuild the system schema to get all of the objects back in? ... this a production database? ... This was the system user- logged in as system and ran a script that ... tablespace from your archived redo logs. ...
    (comp.databases.oracle.server)
  • Re: Ora10g installed...now what ? :-)
    ... Can you explain me please in simple terms the difference from "database" ... Database, in Oracle terms, is simply a set of files. ... schema is equivalent to the master catalog/master database. ... tablespace of Ora and database of Sql server? ...
    (comp.databases.oracle.server)
  • Re: Determining the disk space used by a schema.
    ... I'd like to find out how much disk space is being used by one schema my ... Oracle 10g database. ... My schema is sharing a tablespace with other ... so I can't just check the size of the tablespace. ...
    (comp.databases.oracle.server)
  • Re: Solaris/UFS logging performance issue.
    ... > Some systems here have been upgraded from Solaris 2.6 to ... > As part of the O/S upgrade, ... > run large database jobs has now reduced by 30-50%. ... both the mountoptions logging + forcedirectio ...
    (comp.unix.solaris)