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: Urgent: Can connect internal but hangs when connecting as

RE: Urgent: Can connect internal but hangs when connecting as

From: Ron Rogers <RROGERS_at_galottery.org>
Date: Thu, 03 Aug 2000 14:41:34 -0400
Message-Id: <10578.113772@fatcity.com>


It's been a while since I did any sysadmin work but I remember a unix = command that would check the semiphores in a system and also remove the = semiphores that were phantom to the system and just eating up resources.=20=

May be some of the DBA/sysadmin members can help you out with the = commands. We use to do it on a weekly basis just to prevent troubles = (learned the hard way).
It was something like IPCRM - option. with the input from a IPCS -option = command.
Hope this helps in the future.
Ron Rogers
DBA OCP
Atl.ga
>>> Cherie_Machler_at_gelco.com 08/03/00 12:56PM >>>
Thanks for your reply. I found the problem. After hanging for 20 = minutes,
eventually an
Oracle error was produced that said we are out of operating system memory.

As an aside, does anyone have any formulas for calculating what the shared memory semaphores
should be in /etc/system. I've found a formula for one or two of them = but it's
hard to know
what to set the others to other then just trial and error increasing them.

Thanks,

Cherie

--=20
Author:=20
  INET: Cherie_Machler_at_gelco.com=20

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 03 2000 - 13:41:34 CDT

Original text of this message

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