Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Identifying shared memory segment for oracle instance

Re: Identifying shared memory segment for oracle instance

From: <danut.bancea_at_ifl.bmo.ca>
Date: Wed, 22 Nov 2000 15:28:49 -0500
Message-Id: <10688.122762@fatcity.com>


This is a multipart message in MIME format. --=_alternative 007080BB8525699F_=
Content-Type: text/plain; charset="us-ascii"

Hi,

See oracle note 68281.1. The note said that you can use svrmgrl and oradebug ipc.

Extract from the note.



The following is an example of how to proceed:  

  SVRMGR> connect internal
  Connected.

  SVRMGR> oradebug ipc

  The following output shows the shared memory segment and semaphore segment:  

  Seg Id     Address   Size 
  6665       c4c94000  6422528 

  Semaphore identifiers:
   2828  

  Then look to verify this is running with the following command

  % ipcs -b  

  m    6665 0x5fa37342 --rw-r-----  osupport       dba 6422528 
  s    2828 0x00000000 --ra-r-----  osupport       dba    50 
 
====================================================================

Danut,

Prasada.Gunda1_at_hartfordlife.com
Sent by: root_at_fatcity.com
11/22/00 01:25 PM
Please respond to ORACLE-L  

        To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
        cc: 
        Subject:        Identifying shared memory segment for oracle instance


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).



--=_alternative 007080BB8525699F_=
Content-Type: text/html; charset="us-ascii"


<br><font size=2 face="sans-serif">Hi,</font>
<br>
<br><font size=2 face="sans-serif">See oracle note 68281.1. The note said that you can use svrmgrl and oradebug ipc.</font>
<br>
<br><font size=2 face="sans-serif">Extract from the note.</font>
<br>
<br><font size=2 face="sans-serif">====================================================================</font>
<br><font size=2 face="sans-serif">The following is an example of how to proceed: </font>
<br><font size=2 face="sans-serif">&nbsp; &nbsp;</font>
<br><font size=2 face="sans-serif">&nbsp; SVRMGR&gt; connect internal </font>
<br><font size=2 face="sans-serif">&nbsp; Connected. </font>
<br>
<br><font size=2 face="sans-serif">&nbsp; SVRMGR&gt; oradebug ipc </font>
<br>
<br><font size=2 face="sans-serif">&nbsp; -------------- Shared memory -------------- </font>
<br><font size=2 face="sans-serif">&nbsp; Seg Id &nbsp; &nbsp; Address &nbsp; Size </font>
<br><font size=2 face="sans-serif">&nbsp; 6665 &nbsp; &nbsp; &nbsp; c4c94000 &nbsp;6422528 </font>
<br><font size=2 face="sans-serif">&nbsp; Total: # of segments = 1, size = 6422528 </font>
<br><font size=2 face="sans-serif">&nbsp; -------------- Semaphores ---------------- </font>
<br><font size=2 face="sans-serif">&nbsp; Total number of semaphores = 50 </font>
<br><font size=2 face="sans-serif">&nbsp; Number of semaphores per set = 50 </font>
<br><font size=2 face="sans-serif">&nbsp; Number of semaphore sets = 1 </font>
<br><font size=2 face="sans-serif">&nbsp; Semaphore identifiers: </font>
<br><font size=2 face="sans-serif">&nbsp; &nbsp;2828 </font>
<br><font size=2 face="sans-serif">&nbsp; &nbsp;</font>
<br><font size=2 face="sans-serif">&nbsp; The following output shows the shared memory segment and semaphore segment: </font>
<br><font size=2 face="sans-serif">&nbsp; &nbsp;</font>
<br><font size=2 face="sans-serif">&nbsp; Seg Id &nbsp; &nbsp; Address &nbsp; Size </font>
<br><font size=2 face="sans-serif">&nbsp; 6665 &nbsp; &nbsp; &nbsp; c4c94000 &nbsp;6422528 </font>
<br><font size=2 face="sans-serif">&nbsp; Semaphore identifiers: </font>
<br><font size=2 face="sans-serif">&nbsp; &nbsp;2828 </font>
<br><font size=2 face="sans-serif">&nbsp; &nbsp;</font>
<br><font size=2 face="sans-serif">&nbsp; Then look to verify this is running with the following command</font>
<br>
<br><font size=2 face="sans-serif">&nbsp; % ipcs -b </font>
<br><font size=2 face="sans-serif">&nbsp; &nbsp;</font>
<br><font size=2 face="sans-serif">&nbsp; m &nbsp; &nbsp;6665 0x5fa37342 --rw-r----- &nbsp;osupport &nbsp; &nbsp; &nbsp; dba 6422528 </font>
<br><font size=2 face="sans-serif">&nbsp; s &nbsp; &nbsp;2828 0x00000000 --ra-r----- &nbsp;osupport &nbsp; &nbsp; &nbsp; dba &nbsp; &nbsp;50 </font>
<br><font size=2 face="sans-serif">&nbsp; &nbsp;</font>
<br><font size=2 face="sans-serif">====================================================================</font>
<br>
<br><font size=2 face="sans-serif">Danut,</font>
<br>
<br>
<br>
<br>
<table width=100%>
<tr valign=top>
<td>
<td><font size=1 face="sans-serif"><b>Prasada.Gunda1_at_hartfordlife.com</b></font>
<br><font size=1 face="sans-serif">Sent by: root_at_fatcity.com</font>
<p><font size=1 face="sans-serif">11/22/00 01:25 PM</font>
<br><font size=1 face="sans-serif">Please respond to ORACLE-L</font>
<br>
<td><font size=1 face="Arial">&nbsp; &nbsp; &nbsp; &nbsp; </font>
<br><font size=1 face="sans-serif">&nbsp; &nbsp; &nbsp; &nbsp; To: &nbsp; &nbsp; &nbsp; &nbsp;Multiple recipients of list ORACLE-L &lt;ORACLE-L_at_fatcity.com&gt;</font>
<br><font size=1 face="sans-serif">&nbsp; &nbsp; &nbsp; &nbsp; cc: &nbsp; &nbsp; &nbsp; &nbsp;</font>
<br><font size=1 face="sans-serif">&nbsp; &nbsp; &nbsp; &nbsp; Subject: &nbsp; &nbsp; &nbsp; &nbsp;Identifying shared memory segment for oracle instance</font></table>
<br>
<br><font size=2 face="Courier New"><br>
Hi,<br>
<br>
We have 3 oracle instances(8.1.6) running on unix(hp-ux v11) box.<br>
Following 'ipcs -m' command shows the shared memory segments for 3 instances.<br>
How do I know which shared segment belongs to which oracle instance.<br>
<br>
All your inputs are appreciated.<br>
<br>
Thanks in advance,<br>
Regards,<br>
prasad<br>
<br>

$ ipcs -m<br>
IPC status from /dev/kmem as of Wed Nov 22 13:19:57 2000<br> T &nbsp; &nbsp; &nbsp;ID &nbsp; &nbsp; KEY &nbsp; &nbsp; &nbsp; &nbsp;MODE &nbsp; &nbsp; &nbsp; &nbsp;OWNER &nbsp; &nbsp; GROUP<br> Shared Memory:<br> m &nbsp; &nbsp; &nbsp; 0 0x2fd80002 --rw------- &nbsp; &nbsp; &nbsp;root &nbsp; &nbsp; &nbsp; sys<br> m &nbsp; &nbsp; &nbsp; 1 0x41dc361e --rw-rw-rw- &nbsp; &nbsp; &nbsp;root &nbsp; &nbsp; &nbsp;root<br> m &nbsp; &nbsp; &nbsp; 2 0x4ecc0002 --rw-rw-rw- &nbsp; &nbsp; &nbsp;root &nbsp; &nbsp; &nbsp;root<br> m &nbsp; &nbsp; &nbsp; 3 0x41e0383e --rw-rw-rw- &nbsp; &nbsp; &nbsp;root &nbsp; &nbsp; &nbsp;root<br> m &nbsp; &nbsp; &nbsp; 4 0x0c6629c9 --rw-r----- &nbsp; &nbsp; &nbsp;root &nbsp; &nbsp; &nbsp;root<br> m &nbsp; &nbsp; &nbsp; 5 0x06347849 --rw-rw-rw- &nbsp; &nbsp; &nbsp;root &nbsp; &nbsp; &nbsp;root<br> m &nbsp; 48134 0xb55feaac --rw-r----- &nbsp; &nbsp;oracle &nbsp;oinstall<br> m &nbsp;140296 0x67c69240 --rw-r----- &nbsp; &nbsp;oracle &nbsp;oinstall<br> m &nbsp; &nbsp;8713 0x1a2d39d4 --rw-r----- &nbsp; &nbsp;oracle &nbsp;oinstall<br> <br> <br> <br> -- <br> Please see the official ORACLE-L FAQ: http://www.orafaq.com<br> -- <br> Author: <br> &nbsp;INET: Prasada.Gunda1_at_hartfordlife.com<br> <br> Fat City Network Services &nbsp; &nbsp;-- (858) 538-5051 &nbsp;FAX: (858) 538-5051<br> San Diego, California &nbsp; &nbsp; &nbsp; &nbsp;-- Public Internet access / Mailing Lists<br> --------------------------------------------------------------------<br> To REMOVE yourself from this mailing list, send an E-Mail message<br> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in<br> the message BODY, include a line containing: UNSUB ORACLE-L<br>
Received on Wed Nov 22 2000 - 14:28:49 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US