Do all share the same address space or does each instance get it's own copy of Oracle.exe and it's own 2g address space?
----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, March 11, 2003 10:04 AM > We are running 11 instances on WinNT with no problems! At one point, we had > 26 instances. they are all development instances, so volumn and load are > low. but they all share one Oracle Home. > > Tom Mercadante > Oracle Certified Professional > > > -----Original Message----- > Sent: Tuesday, March 11, 2003 9:19 AM > To: Multiple recipients of list ORACLE-L > > > > I can't remember the last time that I saw a server (other than WinNT) > running a single instance. My experience is that it's quite normal to run > multiple instances on a single server. > > One Oracle home per version of Oracle. I'm not sure what the point of a > separate Oracle home per instance would be. > > On the licensing issue --- that's Oracle's call. We have a site license so > it's not an issue for me. > > > > > > Hemant K Chitale > > <hkchital To: Multiple recipients > of list ORACLE-L <[EMAIL PROTECTED]> > @singnet.com.sg> cc: > > Sent by: root Subject: Running multiple > instances on a [large] server > > > > > 03/11/2003 03:48 > > AM > > Please respond > > to ORACLE-L > > > > > > > > > > > One of the teams here is planning to run anything > from 8 to 16 database instances [no indication on > sizing yet, but gut-feel SGAs are 200MB to 1GB > and DB sizes 500MB to 40GB] on a "large" server, > something like a Sun E6800 or an equivalent > HP or Fujitsu server. > > 1. How many of you do run, and are comfortable running, > multiple databases on the same server, whether it is > "partitioned" or not ? > 2. Do you create a seperate ORACLE_HOME for > each instance ? > 3. Do you just buy the Oracle DB CPU license on the > total number of CPUs on the server ? > > My positioning is > a. We might not be able to create 8 partitions but > partition such that we have a max of 2 or 3 instances > in one partition. Hopefully, I can dynamically change > CPU partitioning to reallocate CPU to another group > of instances. > > b. Each instance should have it's own ORACLE_HOME. > [Disk space is not a constraint]. > > c. Just add up the number of CPUs on the server, > across all partitions, and buy a CPU license. Also, > a CPU license is much preferable to Named-User as some > of these databases would host Portals for 1,000+ end-users. > > > Hemant K Chitale > http://hkchital.tripod.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Hemant K Chitale > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > > > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Thomas Day > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Mercadante, Thomas F > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Chuck Hamilton INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).