Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: 20 Instances 1 Machine

RE: 20 Instances 1 Machine

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Thu, 01 Aug 2002 14:38:25 -0800
Message-ID: <F001.004A968D.20020801143825@fatcity.com>

Ethan - Technically it shouldn't be a problem. Which Unix? What is the objective of 20 instances rather than one instance with 20 schemas? A single instance allows Oracle to allocate resources more efficiently. For example, the data buffer reflects the hottest blocks globally, rather than 20 small data buffers with the hot blocks for each schema. Our test system runs many instances. One thing I've noticed is that if an instance hasn't been used for awhile, it takes a little while to get a response. My assumption is that after awhile the O.S. pages out the little-used memory blocks in favor of the ones being used more frequently.
Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
Sent: Thursday, August 01, 2002 4:58 PM
To: Multiple recipients of list 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: DENNIS WILLIAMS
  INET: DWILLIAMS_at_LIFETOUCH.COM
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 Thu Aug 01 2002 - 17:38:25 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US