Identifying Shared Memory Segments

From: Joseph Blazic <joseph_blazic_at_atu.com.au>
Date: Mon, 25 Sep 2000 00:23:56 +1000
Message-ID: <39cdfef7@pink.one.net.au>

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.

Thanks in advance,
Joseph Received on Sun Sep 24 2000 - 09:23:56 CDT