List of processes attached to shared memory

[Ovidiu D. Raita]

Is Oracle down? If yes, whay don't you kill all the processes that belong to oracle:dba?

Ovidiu

[Fedon Kadifeli]

A new instance of Oracle is running and I'm sure that no process is attached to this shared memory. In other words shutting down Oracle will not help. The problem is with the system. I think we have to reboot the system to clear the memory, but this is a production V2600 system, so cannot reboot it right now. I want to clear the memory without rebooting.

[Steve Bonds · Accepted solution]

Sure, it's been 9 years, but this is still in the top results from Googling.

Using the HP-provided "kmeminfo" utility like this gives tons of good info:

kmeminfo -shmem

For example if "ipcs -m" shows:

-----
T ID KEY MODE OWNER GROUP
Shared Memory:
m 0 0x41181147 --rw-rw-rw- root root
m 1 0x4e0c0002 --rw-rw-rw- root root
m 2 0x411c0b3b --rw-rw-rw- root root
m 3 0x411898ef --rw------- root root

-----

Use kmeminfo like this:

-----
# ./kmeminfo -shmem 2
... trimmed ...
Processes using this segment:
proc=0x52ac4000 (pid 749 "nktl_daemon")
proc=0x52ac8000 (pid 759 "ntl_reader")
-----

And there you have the two PIDs attached to that shared memory segment.

Now you know what to kill or shut down to free up that segment.

-- Steve