Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Running multiple instances on a [large] server
We run upto 22 instances on large SUN boxes... Each environment has their
own oracle home, own file system, and in some cases-their own UNIX account
for the environment..
One loses a little space for the multiple oracle homes, and it does add some
overhead for the operations.. But when we need to migrate a database to a
new server;we can shutdown the DB-umount,mount on the new system, and crank
it up.
We have been in a situation where the machine resources choked, and we were able to move a couple of databases with less than a 3 minute hit for an outage. Would have been less if the operations guys(SA's) had things tee'd up, and ready to hit it with the Driver too.
greg
-----Original Message-----
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.
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: Loughmiller, Greg
INET: Greg.Loughmiller_at_cingular.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 - 11:10:25 CST
![]() |
![]() |