how do I know which which oracle instance created this share memory?

[Ninad_1 · Accepted solution]

Hanry,

This is a very interesting link. Which mentions following steps to corelate the shared memory segment

http://www.orafaq.com/node/8

using svrmgr connect to database
$ svrmgrl
SVRMGR>connect internal
SVRMGR>oradebug ipc

Which gives output like

-------------- Shared memory --------------
Seg Id Address Size
10250 c1eaf000 4591616
Total: # of segments = 1, size = 4591616
-------------- Semaphores ----------------
Total number of semaphores = 50
Number of semaphores per set = 50
Number of semaphore sets = 1
Semaphore identifiers:
188434


Regards,
Ninad