topic kill shared memory in Operating System - HP-UX

kill shared memory

DIEGO_5 — Thu, 10 Mar 2005 12:11:34 GMT

Hi all
I have a trouble with oracle shared memory, I want kill a shared memory process in hang, how Can i do?

Re: kill shared memory

RolandH — Thu, 10 Mar 2005 12:18:35 GMT

Read the Manpage from ipcrm.

Can not give more advice because of less information.

Roland

Re: kill shared memory

A. Clay Stephenson — Thu, 10 Mar 2005 12:19:00 GMT

Do an ipcs -ma and note the NATTCH column. If that value is zero then also note the corresponding value in the ID column.

You then issue this command ipcrm -m ID.

NOTE: NATTCH = 0 is a necessary but not necessarily sufficient condition for the safe removal of a shared memory segment. It all depends on how the code using the shared memory was written. I assume that you have already shutdown (even if you had to use shutdown abort) the instance.

Re: kill shared memory

Steven E. Protter — Thu, 10 Mar 2005 12:20:38 GMT

ipcs command shows the memory.

ipcrm command kills it.

lets say its listed under the m section.

ipcrm -m

SEP

Re: kill shared memory

TwoProc — Thu, 10 Mar 2005 12:21:54 GMT

run "ipcs -am" and look at the memory segments there - focusing on the ones owned by oracle. Also, review start times and number attached NATTCH.

To delete it from memory - use ipcrm command (do a man on it for syntax). If the database is down and no others are running then this is pretty save process. If you're hunting down remnants of an old run while a new one instance is up - this is bit more tricky. Evaluating the start times and number attachments is the key for that analysis. But, if you have Oracle running - be careful, b/c naturally pulling the shmem from a running database will douse the whole thing (and hey, at least you hope it would and not keep writing to the disk and screw up your db).

Re: kill shared memory

DIEGO_40 — Thu, 10 Mar 2005 17:06:51 GMT

ok I tried ipcrm command and it's good..thanks to all