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

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