This article describes how to identify which shared memory and semaphore
segments are owned by a particular instance, in Oracle8i.
If you have several instances running on the Unix and one instance crashes, it may leaves shared memory and semaphore segments running. As there are many instances running, you are unsure which segments to kill and when to do an ipcs. You may see several shared memory and semaphore segments when executing at the shell.
Connect as internal
SVRMGR> connect internal
Information will be written to trace file in USER_DUMP_DEST
The command syntax to remove the shared memory segments or
semaphores is as follows: