Oracle-L: Re: Re[2]: Running multiple instances on a [large] server

From: Thomas Day <tday6_at_csc.com>
Date: Tue, 11 Mar 2003 08:49:41 -0800
Message-ID: <F001.00566346.20030311084941@fatcity.com>

I do have multiple databases on a Win2K server. No problems except that MicroSoft just loves to write the SGA out to the swap file (about 630M of SGA, 1.3G of RAM and disk i/o out the wazzoo). I don't know if there was some specific reason that we never ran more than one instance on WinNT 4.0 but we never did. On WinNT it was one instance, one server.

                                                                                                                                       
                      dgoulet                                                                                                          
                      @vicr.com                To:      Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>                    
                      Sent by: root            cc:                                                                                     
                                               Subject: Re[2]: Running multiple instances on a [large] server                          
                                                                                                                                       
                      03/11/2003 09:54                                                                                                 
                      AM                                                                                                               
                      Please respond                                                                                                   
                      to ORACLE-L

Thomas,

Now that's an interesting comment. I can't remember ever seeing more than
one instance on an NT machine either except when we were playing around & boy
did that crash in a big hurry (NT 4.0 Oracle 8.0). On the other hand I've set
up Linux with 4 instances (same piece of hardware) and had no problems. Got to
love the Penguin.

Dick Goulet

____________________Reply Separator____________________
Author: "Thomas Day" <tday6_at_csc.com>
Date:       3/11/2003 6:19 AM

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.

How many of you do run, and are comfortable running, multiple databases on the same server, whether it is "partitioned" or not ?
Do you create a seperate ORACLE_HOME for each instance ?
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: 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

--

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

--

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