| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 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:
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 oinstallPGhc> 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 Liststo: 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 Received on Wed Nov 22 2000 - 14:09:08 CST
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
 |
 |