Re: ipcs -m output

An (more kludgy) alternative to Kevin's is to look at the creation dates of the ipcs entries and the corresponding pmon/smon services (using ps -ef | grep ora, or something). Of course, if both started at the same time, that won't work either - but there's usually a bit of time between them, even if they started using dbstart.

Len

>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 Sat Apr 21 2001 - 10:35:18 CDT