Re: ipcs -m output

From: andrew_webby at hotmail <spam_at_no.thanks.com>
Date: Mon, 23 Apr 2001 11:00:25 +0100
Message-ID: <988020064.14733.0.nnrp-14.c30bdde2@news.demon.co.uk>

The Solaris method is (example for me finding RBDEV segment follows):

$ ps -ef|grep pmon

  oracle   568     1  0 00:50:04 ?        0:00 ora_pmon_HOUDEV
  oracle   570     1  0 00:50:04 ?        0:00 ora_pmon_HOUTEST
  oracle   572     1  0 00:50:04 ?        0:00 ora_pmon_RBTEST
  oracle   574     1  0 00:50:04 ?        0:00 ora_pmon_RBDEV
  oracle   610     1  0 00:50:07 ?        0:00 ora_pmon_HOULIVE
  oracle   597     1  0 00:50:07 ?        0:00 ora_pmon_RBLIVE
  oracle 17352 17045  0 10:51:32 pts/4    0:00 grep pmon

$

$ ipcs -mas|egrep ^m

m          0   0x500e0dd9 --rw-r--r--     root     root     root     root
1         68  1178  1178 19:56:54 19:56:54 19:56:54
m          1   0x790      --rw-rw-rw-     root     root     root     root
1       4008  1294  1294 19:57:10 no-entry 19:57:10
m          2   0x2957df44 --rw-r-----   oracle      dba   oracle      dba
144  256925696   565 13192 10:47:45 10:50:17  0:50:02
m          3   0xb45ab788 --rw-r-----   oracle      dba   oracle      dba
7  105676800   564 17390 10:51:58 10:51:58  0:50:02
m          4   0xc8d6e2b4 --rw-r-----   oracle      dba   oracle      dba
7  105676800   563 17378 10:51:53 10:51:54  0:50:02
m          5   0xaa5e5990 --rw-r-----   oracle      dba   oracle      dba
10   89505792   562 17365 10:51:37 10:51:53  0:50:02
m          6   0x1503facc --rw-r-----   oracle      dba   oracle      dba
9   87195648   560 17349 10:51:30 10:51:33  0:50:03
m          7   0x45bba54c --rw-r-----   oracle      dba   oracle      dba
189  300638208   561 17369 10:51:41 10:51:41  0:50:03
m          8   0x280267   --rw-r--r--     root     root     root     root
17     102400 16585 14614 10:48:43 10:51:28  2:31:50

$
$ /usr/proc/bin/pmap 574|egrep shared
80000000 85152K read/write/exec/shared [ shmid=0x6 ] FF170000 8K read/write/exec/shared [ anon ]

So there you have it. The shared memory segment is segment number 6.

"Phillip" <tienp_at_wholefoods.com> wrote in message news:3AE0A374.99D88AF_at_wholefoods.com...
> Does anyone out there know how to correspond shared memory segments with
> database SIDs? For example, if I have multiple instances configured on
> a machine and I run the ipcs -m command, how can I tell which memory
> segment correspond to which database? Please copy tienp_at_wholefoods.com
> on all replies. Thanks.
>
> --
> Phillip
>
Received on Mon Apr 23 2001 - 05:00:25 CDT