Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Impact of two databases sharing an oracle instance

Impact of two databases sharing an oracle instance

From: Nirupam <nirupam.newaskar_at_fmr.com>
Date: 2 Nov 2005 23:17:05 -0800
Message-ID: <1131002225.268852.39330@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
Received on Thu Nov 03 2005 - 01:17:05 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US