| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Urgent: Can connect internal but hangs when connecting as
$ ipcs -m
IPC status from <running system> as of Thu Aug 3 14:34:28 MDT 2000
T ID KEY MODE OWNER GROUP
Shared Memory:
m 100 0x4d4e5251 --rw-r--r-- root other
$ ipcs -s
IPC status from <running system> as of Thu Aug 3 14:34:39 MDT 2000
T ID KEY MODE OWNER GROUP
Semaphores:
s 65537 0x55535253 --ra-ra-ra- root other s 458754 0 --ra-r----- oracle dba
-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Ron Rogers
Sent: Thursday, August 03, 2000 1:55 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Urgent: Can connect internal but hangs when connecting as
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.
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
-- 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). -- Author: Ron Rogers INET: RROGERS_at_galottery.org 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 mayReceived on Thu Aug 03 2000 - 15:40:44 CDT
 |
 |