Re: Help: Which instance is for which shared memory

u132781982_at_spawnkill.ip-mobilphone.net wrote:

> we have three instance running on our
> box, after shutdown the database, ipcs -mas
> still show three piece, i want to use
> ipcrm -m 400 to free the memory, but how can
> you tell which one is the right one to free?

If you don't know *for sure* how to determine the right segment to remove, DO NOT attempt to remove ANY segments. Deleting shared memory segments that are attached to a running Oracle DB will cause data corruption. (I know this from experience!)

Safe method: shut all instances down, clean up shared memory and semaphores, then start everything up again. Bear in mind that programs other than Oracle used shared memory, so tread warily even with this approach.

• Phil