Re: Identifying shared memory segment for oracle instance

Thanks for your input.

What if all instances have the same SGA size?

Regards,
Prasad

"Mohammad Rafiq" <rafiq9857_at_hotmail.com> on 11/22/2000 03:00:25 PM

Please respond to ORACLE-L_at_fatcity.com

                                                                            
                                                                            
                                                                            


                                                              
                                                              
                                                              
 To:      Multiple recipients of list ORACLE-L                
          <ORACLE-L_at_fatcity.com>                              
                                                              
 cc:      (bcc: Prasada R Gunda/HLIFE)                        
                                                              
                                                              
                                                              
 Subject: Re: Identifying shared memory segment for oracle    
          instance                                            
                                                              

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