Re: Identifying Shared Memory Segments

In comp.unix.aix Joseph Blazic <joseph_blazic_at_atu.com.au> wrote:
> Hi All,
 

> I have a UNIX (AIX) box running two oracle instances.
> Both instance's processes (at the moment) have the same owner and group.
> Anyone have any suggestions on how to identify shared memory segments based
> on SID?
 

> In AIX, ipcs -am lists information about shared memory segments. As far as
> I can tell, this listing does not provide any information which can,
> cross-referencing the oracle alert log, definitively identify the instance.
> For example, creation time is listed, but only the clock time, not date.
> Further, the creation time does not necessarily match to-the-second with any
> instance-up event in the alert log.
 

> Unfortunately I am stuck (for now) with an old version of oracle which
> suffers from space leaks...which requires manually clearing-out shared
> memory segments before re-starting oracle. The segments must be
> unambiguously identified; I wish to script some automation.

It lists the process id that created the segment. That's probably your best bet, isn't it?

Regards,

Nick Dronen Received on Sun Sep 24 2000 - 11:17:28 CDT