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

Home -> Community -> Mailing Lists -> Oracle-L -> What parameters affect the relationship between semaphores and

What parameters affect the relationship between semaphores and

From: <Cherie_Machler_at_gelco.com>
Date: Wed, 14 Feb 2001 13:40:59 -0800
Message-ID: <F001.002B4838.20010214125545@fatcity.com>

I was under the impression that you need at least one semaphore per process. On one of our boxes, we are short of semaphores. We took down one 7.3.4 database with 200 processes, and two 8.1.5 databases with 100 processes each and temporarily bumped up the number of processes in the QA database by 400. At that point, we were unable to start up the QA database due to a shortage of semaphores.

Why is it that we could distribute those 400 processes among four databases and they would all come up at once but when I consolidated them in a single database, it would not come up?

I figure it must be a difference in the init.ora file of the QA database. What things might affect the ratio between processes and semaphores.

Short of increasing the semaphores in /etc/system and bouncing the box (which is not a great option), what else might we try tweaking in the QA database to enable it to come up in the current operating system environment.

Thanks in advance,

Cherie

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author:
  INET: Cherie_Machler_at_gelco.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 Wed Feb 14 2001 - 15:40:59 CST

Original text of this message

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