Re: Identifying shared memory segment for oracle instance

From: Jonathan Gennick <jonathan_at_gennick.com>
Date: Wed, 22 Nov 2000 14:51:24 -0500
Message-Id: <10688.122757@fatcity.com>

Hello Prasada,

I just finished editing a book with this information in it. Run Server Manager, connect as INTERNAL, and issue the oradebug ipc command:

SVRMGR> connect internal;

Connected.

SVRMGR> oradebug ipc

Shared memory information written to trace file.

You'll have to go hunt for the trace file. When you find it, you'll see output like this:

Semaphores ------------------ Total number of semaphores = 100 Number of semaphores per set = 100 Number of semaphore sets = 1 Semaphore identifiers: 14825

The semaphore identifier, 14825 in this case, corresponds to the ID column in the ipcs output.

Thank Don Burleson for this tip, and blame me if I misinterpreted what he wrote. It's from his upcomming book, Unix for Oracle DBAs Pocket Reference. It should be available late December or early January.

Best regards,

Jonathan
mailto:jonathan_at_gennick.com
http://gennick.com

Wednesday, November 22, 2000, 1:25:49 PM, you wrote:

PGhc> Hi,

PGhc> We have 3 oracle instances(8.1.6) running on unix(hp-ux v11) box.
PGhc> Following 'ipcs -m' command shows the shared memory segments for 3 instances.
PGhc> How do I know which shared segment belongs to which oracle instance.

PGhc> All your inputs are appreciated.

PGhc> Thanks in advance,
PGhc> Regards,
PGhc> prasad

PGhc> $ ipcs -m
PGhc> IPC status from /dev/kmem as of Wed Nov 22 13:19:57 2000
PGhc> T      ID     KEY        MODE        OWNER     GROUP
PGhc> Shared Memory:
PGhc> m       0 0x2fd80002 --rw-------      root       sys
PGhc> m       1 0x41dc361e --rw-rw-rw-      root      root
PGhc> m       2 0x4ecc0002 --rw-rw-rw-      root      root
PGhc> m       3 0x41e0383e --rw-rw-rw-      root      root
PGhc> m       4 0x0c6629c9 --rw-r-----      root      root
PGhc> m       5 0x06347849 --rw-rw-rw-      root      root

PGhc> m 48134 0xb55feaac --rw-r----- oracle oinstall PGhc> m 140296 0x67c69240 --rw-r----- oracle oinstall Received on Wed Nov 22 2000 - 13:51:24 CST