Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: ipcs -m output
On my platform ( AIX ), ipcs -am has CPID and LPID.
CPID=process id of the creator
LPID=process id of the last process to attach or detach
While none of the CPID processes still exist ( I've got about 5 instances on this particular machine ), the LPID entry is dynamic. So, I just start a session and connect to a database, then look for the pid of my host process ( oracle<SID> ) in the LPID column of the ipcs output. This maps SID to SM segment.
Kind of clunky but it works.
-Kevin
"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 Fri Apr 20 2001 - 17:37:03 CDT