RE: Identifying shared memory segment for oracle instance

Another quick ( and not so dirty ) way to find it out on both Oracle7 & Oracle8 versions ( this works on solaris, at least )

/usr/proc/bin/pmap PID (DBWR for ex.)

gives you the amount of shared memory used, ex : 194480K (199147520 bytes) in :

xxxxxxxx 194480K read/write/exec/shared [ shmid=0x1784 ]

ipcs -mb : you will find a shared memory segment of size 199147520.

If you're good at hex/dec conversions, you can see that this segment ID is 6020 ( in my case ) = 0x1784

so you can use either the size or the segment ID.

> ----------
> From:
> Prasada.Gunda1_at_hartfordlife.com[SMTP:Prasada.Gunda1_at_hartfordlife.com]
> Reply To: ORACLE-L_at_fatcity.com
> Sent: Wednesday, November 22, 2000 21:10
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Identifying shared memory segment for oracle instance
>
>
> Jonathan,
>
> Thank you very much for your input.
>
> Looking forward to see 'Unix for Oracle DBAs Pocket Reference' book.
>
> Regards,
> Prasad
>
>
>
>
>
>
>
> Jonathan Gennick <jonathan_at_gennick.com> on 11/22/2000 02:51:00 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
>
>
>
>
>
>
>
>
> Hello Prasada,
>
> I just finished editing a book with this information in it.
> Run Server Manager, connect as INTERNAL, and issue the
> oradebug ipc command:
>
> SVRMGR> connect internal;
>
> Connected.
>
> SVRMGR> oradebug ipc
>
> Shared memory information written to trace file.
>
> You'll have to go hunt for the trace file. When you find it,
> you'll see output like this:
>
> ------------------ Semaphores ------------------
> Total number of semaphores = 100
> Number of semaphores per set = 100
> Number of semaphore sets = 1
> Semaphore identifiers:
> 14825
>
> The semaphore identifier, 14825 in this case, corresponds
> to the ID column in the ipcs output.
>
> Thank Don Burleson for this tip, and blame me if I
> misinterpreted what he wrote. It's from his upcomming
> book, Unix for Oracle DBAs Pocket Reference. It should be
> available late December or early January.
>
>
> Best regards,
>
> Jonathan
> mailto:jonathan_at_gennick.com
> http://gennick.com
>
>
> Wednesday, November 22, 2000, 1:25:49 PM, you wrote:
>
>
> PGhc> Hi,
>
> PGhc> We have 3 oracle instances(8.1.6) running on unix(hp-ux v11) box.
> PGhc> Following 'ipcs -m' command shows the shared memory segments for 3
> instances.
> PGhc> How do I know which shared segment belongs to which oracle instance.
>
> PGhc> All your inputs are appreciated.
>
> PGhc> Thanks in advance,
> PGhc> Regards,
> PGhc> prasad
>
> PGhc> $ ipcs -m
> PGhc> IPC status from /dev/kmem as of Wed Nov 22 13:19:57 2000
> PGhc> T ID KEY MODE OWNER GROUP
> PGhc> Shared Memory:
> PGhc> m 0 0x2fd80002 --rw------- root sys
> PGhc> m 1 0x41dc361e --rw-rw-rw- root root
> PGhc> m 2 0x4ecc0002 --rw-rw-rw- root root
> PGhc> m 3 0x41e0383e --rw-rw-rw- root root
> PGhc> m 4 0x0c6629c9 --rw-r----- root root
> PGhc> m 5 0x06347849 --rw-rw-rw- root root
> PGhc> m 48134 0xb55feaac --rw-r----- oracle oinstall
> PGhc> m 140296 0x67c69240 --rw-r----- oracle oinstall
> PGhc> m 8713 0x1a2d39d4 --rw-r----- oracle oinstall
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Jonathan Gennick
> INET: jonathan_at_gennick.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).
>
>
>
> --
> 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
Received on Thu Nov 23 2000 - 04:57:45 CST