Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Running multiple instances on a [large] server
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 <ORACLE-L_at_fatcity.com> @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.
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: hkchital_at_singnet.com.sg 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: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-LReceived on Tue Mar 11 2003 - 08:19:16 CST
(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: tday6_at_csc.com 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: ListGuru_at_fatcity.com (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).
![]() |
![]() |