Re: Identifying Shared Memory Segments

if that is all you need is the full time/date... The different times specified in the 'ipcs' command are actually stored in 'time_t' format...
...with means it contains the full time/date...

Which makes it accessable from a C program... ...use the shmctl() call i.e.:

	#include <sys/shm.h>
	struct shmid_ds my_shmid_ds;
	shmctl(shm_id, IPC_STAT, &my_shmid_ds);
	printf("Create PID: %d\n", my_shmid_ds.shm_cpid);
	printf("last chg:       %s\n",
	      asctime(localtime(&my_shmid_ds.shm_ctime)));

>"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