Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re:RE: Running multiple instances on a [large] server
We also run several instances on just about every server we have. Most, but not
all share the same Oracle_home. I only create new ones for newer versions of
Oracle, but for each database I prefer to use seperate mount points such as:
/test/system
/test/rbs
/test/temp
/prod1/system
/prod1/rbs
/prod1/temp
/prod2/system
etc.......
Keeps one from stepping on one's own _________. (You fill in the blanks.)
The biggest problem I think you'll face is physical memory. Have too little with too big an SGA & you start swapping. Have smaller SGA's and wait IO can become a problem. Simply put, you just can't have too much memory.
Typically we license a server for whatever it's being used for, so yes we do have user and cpu licenses. Kind of a pain keeping track.
Dick Goulet
____________________Reply Separator____________________ Author: "Stephane Paquette" <stephane.paquette_at_standardlife.ca> Date: 3/11/2003 6:19 AM
Hi,
On one of the 7 development box (aix 4.3.3) we have 27 instances Oracle
8172.
All using the same oracle_home.
I can't say it's the fastest response time ;-)
As for the licensing we have a mix of CPU and user licences.
Stephane Paquette
Administrateur de bases de donnees
Database Administrator
Standard Life
www.standardlife.ca
Tél. (514) 925-7187
stephane.paquette_at_standardlife.ca <mailto:stephane.paquette_at_standardlife.ca>
-----Original Message-----
Chitale
Sent: Tuesday, March 11, 2003 3:49 AM
To: Multiple recipients of list 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.
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: 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-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: Stephane Paquette INET: stephane.paquette_at_standardlife.ca 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: dgoulet_at_vicr.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).Received on Tue Mar 11 2003 - 08:49:30 CST