kill shared memory

[DIEGO_5]

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

[RolandH]

Read the Manpage from ipcrm.

Can not give more advice because of less information.

Roland

[A. Clay Stephenson]

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.

[Steven E. Protter]

ipcs command shows the memory.

ipcrm command kills it.

lets say its listed under the m section.

ipcrm -m

SEP

[TwoProc]

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).

[DIEGO_40]

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