Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> re : Running multiple instances on a [large] server -- Thanks

re : Running multiple instances on a [large] server -- Thanks

From: Hemant K Chitale <>
Date: Wed, 12 Mar 2003 00:38:39 -0800
Message-ID: <>

Re :

>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 ?

The consensus seems to be that
1. Multiple database instances on one server is doable and IS done. [Although some of those quoting a large number of instances were talking of Development environments, not Production]. However, issues with SGA sizing/resizing may arise. I'd have to be careful to pre-size the SGAs well enough --- the total size should be well below the physical RAM available. [BTW, our "System Integrators" say that all their applications are currently certified on 8.1.7 and Top Damagement has decided to stick to 8.1.7 overriding my request for certification for 9i before the applications go live].

2. Some go for shared ORACLE_HOMEs, others go for seperate. I will still go for seperate ORACLE_HOMEs for the reasons

    i.   Maintenance and Patching are seperated.
   ii.   Upgrades of individual databases are easier.
  iii.   In the future it allows me to "hand-over" ownership of the databases
to different DBA[s] if the need arises.

3. A mix of CPU + NamedUser licensing has been adopted by some sites. However, I still believe Oracle would just count the total number of CPUs on that one server and charge the license for that count, regardless of the number of database instances running. Therefore, I would just buy the CPU license and not have to pay seperately for a NamedUser license for any databases on the same server.

thanks everybody !

Hemant K Chitale
My personal web site is :

Please see the official ORACLE-L FAQ:
Author: Hemant K Chitale

Fat City Network Services    -- 858-538-5051
San Diego, California        -- Mailing list and web hosting services
To REMOVE yourself from this mailing list, send an E-Mail message
to: (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 Wed Mar 12 2003 - 02:38:39 CST

Original text of this message