Re: Identifying Shared Memory Segments

Joseph,

        Does the CreatePID help to isolate it???

-tony

In article <sssaf3kd297jbb_at_corp.supernews.com>, Dave A <dave_and_vanna_at_hotmail.com> wrote:
>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
>>

-- 
Anti-spam filter: I am not root_at_localhost 
trb_at_teleport dot com   COM  Public Access User --- Not affiliated with Teleport