Re: Identifying shared memory segment for oracle instance

From: Mohammad Rafiq <rafiq9857_at_hotmail.com>
Date: Wed, 22 Nov 2000 16:26:23 -0500
Message-Id: <10688.122766@fatcity.com>

Practically in live situation , SGA differs for different instances. You can then use procedure as given by other post. Regards
Rafiq

From: Prasada.Gunda1_at_hartfordlife.com
Reply-To: ORACLE-L_at_fatcity.com
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Subject: Re: Identifying shared memory segment for oracle instance Date: Wed, 22 Nov 2000 13:10:48 -0800

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

--

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