RE: shared memory processes and oracle instances

Couldn't you do this in Oracle 8 using "oradebug ipc"? It should give you the shared memory id associated with the SID...

--Walt Weaver
  Bozeman, Montana, USA

-----Original Message-----
From: Deshpande, Kirti [mailto:Kirti.Deshpande_at_gtedc.gte.com] Sent: Tuesday, June 06, 2000 8:11 AM
To: Multiple recipients of list ORACLE-L Subject: RE: shared memory processes and oracle instances

Hi,
Here is how to do this with 7.3.x databases...

Get the o/p from 'ipcs -m' command as below: IPC status from /dev/kmem as of Tue Jun 6 07:40:40 2000 T ID KEY MODE OWNER GROUP Shared Memory:

m    6309 0x7965c84f --rw-r-----    oracle       dba
m    6310 0x7965c9a3 --rw-r-----    oracle       dba
m    7711 0x79775045 --rw-r-----    oracle       dba
m   13312 0x796b4eb3 --rw-r-----    oracle       dba
m   14013 0x7968cfb8 --rw-rw----    oracle       dba
m   20314 0x790a4eea --rw-r-----    oracle       dba
m      15 0x79614f93 --rw-r-----    oracle       dba
m      16 0x79624f8b --rw-r-----    oracle       dba
m      17 0x7908cf8f --rw-r-----    oracle       dba
m    8418 0x796ecf27 --rw-rw----    oracle       dba
m      19 0x7908cefa --rw-r-----    oracle       dba
m      20 0x7962cf4b --rw-r-----    oracle       dba
m      21 0x790a4f37 --rw-r-----    oracle       dba

Then, use 'od -d sgadef<SID>.dbf' command for the SID in question to get a display as below.
My SID is YPPD...

df2hp019 [YPPD]: od -d sgadefYPPD.dbf
0000000 00000 00001 00000 00432 57287 57344 65535 65535 0000020 00312 24576 00000 00000 00000 08418 65535 65535 0000040 31086 53031 47470 53031 00000 00001 00000 01948 0000060 65535 65535 65535 65535 65535 65535 65535 65535 *
0000124
df2hp019 [YPPD]:

Look across the 2nd line (starting with 0000020) and get the value in col # 3 from the far right. In my example, it is 08418. It is the Shared Memory ID, my SID (YPPD) is using. Look for it in the display from 'ipcs -ma' to get other related information.

However, this process won't work with Oracle 8.x datatabases, as file sgadef.dbf became obsolete. I have not found any way, yet, to associate shared memory segment id to the sid.
If anyone else know, please post the answer...

Here is what is in sgadef file for Oracle 8.0.6 databases when I viewed it with 'cat' command:

df2hp105 [IWHP]: cat sgadefIWHP.dbf
This file is now obsolete. It will be removed in a future release. To determine whether an instance is up, you should check for the existence of the PMON process associated with the instance.

Hope this is what you were after...

• Kirti

> -----Original Message-----
> From: ALEMU Abiy [SMTP:abiy.alemu_at_criltechnology.com]
> Sent: Tuesday, June 06, 2000 1:24 AM
> To: Multiple recipients of list ORACLE-L
> Subject: shared memory processes and oracle instances
>
> I have several instances running and I would like to know which shared
> process correspond to a given instance from those that I see with the
> command ipcs. Is there any way to associate these processes with the
> instances (an id number to designate) ?
> --
> Author: ALEMU Abiy
> INET: abiy.alemu_at_criltechnology.com
>
>

-- 
Author: Deshpande, Kirti
  INET: Kirti.Deshpande_at_gtedc.gte.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