Oracle-L: Re: 20 Instances 1 Machine

From: <DBarbour_at_austin.isd.tenet.edu>
Date: Sat, 03 Aug 2002 09:33:20 -0800
Message-ID: <F001.004AAC1E.20020803093320@fatcity.com>

Twenty Instances? At 500M per SGA, you're talking a minimum of 12+ G of RAM. How many users per instance? More RAM. Are these OLTP or Datawarehousing type DBs? Disk and I/O and RAM. 24 x 7? If one has to be, then you're going to need some type of failover/standby capability. What vendor applications will be supported? More RAM. Any Corba brokers? More RAM. What flavor of UNIX are you on right now?

David A. Barbour
AISD

                                                                                                                   
                    "Post, Ethan"                                                                                  
                    <Ethan.Post_at_ps       To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>       
                    .net>                cc:                                                                       
                    Sent by:             Subject:     20 Instances 1 Machine                                       
                    root_at_fatcity.c                                                                                 
                    om                                                                                             
                                                                                                                   
                                                                                                                   
                    08/01/2002                                                                                     
                    04:58 PM                                                                                       
                    Please respond                                                                                 
                    to ORACLE-L

I got a request to spec out a machine that could handle 20 separate Oracle instances on a single UNIX server. SGA should total about 500 MB per instance. We have some hosts here with 6-8 instances but never tried 20 before. Wondering what types of things I should be worried about, obviously
having enough memory but are there any other limitations I can expect? Anyone had to do this?

Thanks,
Ethan

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Post, Ethan
  INET: Ethan.Post_at_ps.net

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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.com
-- 
Author: 
  INET: DBarbour_at_austin.isd.tenet.edu

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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 Sat Aug 03 2002 - 12:33:20 CDT