Re: Any way to determine which UNIX shared memory belonged to a ORACLE

Hi,

  From svrmgrl give the command

  oradebug ipc

  Use the shared memory id in the output to find the shared memory segment owned by the instance. I have not tried this on AIX, but I think this should work.

Regards,
Denny
---
Denny Koovakattu
denny_at_vitalsol.com
http://vitalsol.com/

On Vincent Ventrone wrote:
>To: "comp.databases.oracle.server_at_list.deja.com" <comp.databases.oracle.server_at_list.deja.com>
>Reply-To: "comp.databases.oracle.server_at_list.deja.com" <comp.databases.oracle.server_at_list.deja.com>
>
>Tim Lim wrote:
>>
>> HI there,
>>
>> We have multiple DB instances running on our AIX server.
>>
>> Anyone know how to associate which Shared Memeoy segment on the system
>> belonged to which ORACLE DB.
>AFAIK this is a common problem & most people simply try to associate the
>attach time (displays as ATIME I believe) with the startup time of the
>database (as listed in the alert.log)
>
>Not great esp. if all instances started pretty much together....Maybe
>someone else has a better suggestion?
>--
>Vincent Ventrone | The MITRE Corp.
>DBA, Dept. R101 | M/S C020
>vav_at_mitre.org | 202 Burlington Rd.
>(781) 271-7048 | Bedford, MA 01730

--== Sent via Deja.com http://www.deja.com/ ==-- Share what you know. Learn what you don't.

 Sent via Deja.com http://www.deja.com/  Share what you know. Learn what you don't. Received on Tue Sep 07 1999 - 14:39:53 CDT