Re: Identifying Shared Memory Segments

The only think I can think of is to see which segment has the earliest date/time and match that to the order the instances are started on the box. No, the times may not match to the second, but the order will be correct.

You could compare the date/time stamp *order* on the smon process to the date/time stamp *order* on the memory segment.

--
Dave A


"Joseph Blazic" <joseph_blazic_at_atu.com.au> wrote in message
news:39cdfef7_at_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

>

>