Re: Identifying shared memory segment for oracle instance

Prasad,

You may also try "oradebug ipc" from svrmgrl . This will create a trace file in the user_dump_destination having the information about the shared memory & semaphores for the specific instance. You may have to repeat this for all the instances.

Regards

Sukumar Kurup

• Mohammad Rafiq <rafiq9857_at_hotmail.com> wrote:
  > It is better to use
  > ipcs -mb
  > and this will give you size of shared memory
  > segments and you may compare
  > it with size of your instances SGA.
  >
  > The output will be as follows:
  > Regards
  > Rafiq
  >
  >
  > => ipcs -mb
  > IPC status from /dev/kmem as of Wed Nov 22 14:55:41
  > 2000
  > T ID KEY MODE OWNER GROUP
  > SEGSZ
  > Shared Memory:
  > m 2800 0x41182287 --rw-rw-rw- bin root
  > 8785
  > m 1 0x4e040002 --rw-rw-rw- root root
  > 31008
  > m 2 0x41200a61 --rw-rw-rw- root root
  > 8192
  > m 1203 0x4d4e5251 --rw-r--r-- root root
  > 109568
  > m 4 0x55315352 --rw-rw-rw- root root
  > 4096
  > m 5 0x44525354 --rw-r--r-- root root
  > 393216
  > m 6 0x53494152 --rw-r--r-- root root
  > 512
  > m 1207 0x0c6629c9 --rw-r----- root root
  > 12918784
  > m 8 0x06347849 --rw-rw-rw- root root
  > 77384
  > m 13609 0x41182280 --rw-rw-rw- bin root
  > 8785
  > m 410 0x41182279 --rw-rw-rw- bin root
  > 8785
  > m 167211 0x5f5a7c8a --rw-rw---- oracle dba
  > 23392256
  > m 812 0x5febf3b5 --rw-rw---- oracle dba
  > 78741504
  > m 813 0x5ffaf241 --rw-rw---- oracle dba
  > 34492416
  > m 414 0x5febf413 --rw-rw---- oracle dba
  > 29888512
  >
  >
  > Reply-To: ORACLE-L_at_fatcity.com
  > To: Multiple recipients of list ORACLE-L
  > <ORACLE-L_at_fatcity.com>
  > Date: Wed, 22 Nov 2000 10:25:50 -0800
  >
  >
  > Hi,
  >
  > We have 3 oracle instances(8.1.6) running on
  > unix(hp-ux v11) box.
  > Following 'ipcs -m' command shows the shared memory
  > segments for 3
  > instances.
  > How do I know which shared segment belongs to which
  > oracle instance.
  >
  > All your inputs are appreciated.
  >
  > Thanks in advance,
  > Regards,
  > prasad
  >
  > $ ipcs -m
  > IPC status from /dev/kmem as of Wed Nov 22 13:19:57
  > 2000
  > T ID KEY MODE OWNER GROUP
  > Shared Memory:
  > m 0 0x2fd80002 --rw------- root sys
  > m 1 0x41dc361e --rw-rw-rw- root root
  > m 2 0x4ecc0002 --rw-rw-rw- root root
  > m 3 0x41e0383e --rw-rw-rw- root root
  > m 4 0x0c6629c9 --rw-r----- root root
  > m 5 0x06347849 --rw-rw-rw- root root
  > m 48134 0xb55feaac --rw-r----- oracle oinstall
  > m 140296 0x67c69240 --rw-r----- oracle oinstall
  > m 8713 0x1a2d39d4 --rw-r----- oracle oinstall
  >
  >
  >
  > --
  > Please see the official ORACLE-L FAQ:
  > http://www.orafaq.com
  > --
  > Author:
  > INET: Prasada.Gunda1_at_hartfordlife.com
  >
  > Fat City Network Services -- (858) 538-5051 FAX:
  > (858) 538-5051
  > San Diego, California -- Public Internet
  > access / Mailing Lists
  >

  ---

  
  > To REMOVE yourself from this mailing list, send an
  > E-Mail message
  > to: ListGuru_at_fatcity.com (note EXACT spelling of
  > 'ListGuru') and in
  > the message BODY, include a line containing: UNSUB
  > ORACLE-L
  > (or the name of mailing list you want to be removed
  > from). You may
  > also send the HELP command for other information
  > (like subscribing).
  >
  >

  ---

  
  > Get more from the Web. FREE MSN Explorer download :
  > http://explorer.msn.com
  >
  > --
  > Please see the official ORACLE-L FAQ:
  > http://www.orafaq.com
  > --
  > Author: Mohammad Rafiq
  > INET: rafiq9857_at_hotmail.com
  >
  > Fat City Network Services -- (858) 538-5051 FAX:
  > (858) 538-5051
  > San Diego, California -- Public Internet
  > access / Mailing Lists
  >

  ---

  
  > To REMOVE yourself from this mailing list, send an
  > E-Mail message
  > to: ListGuru_at_fatcity.com (note EXACT spelling of
  > 'ListGuru') and in
  > the message BODY, include a line containing: UNSUB
  > ORACLE-L
  > (or the name of mailing list you want to be removed
  > from). You may
  > also send the HELP command for other information
  > (like subscribing).
  

  ---