Re: No shared memory for Oracle with ipcs under Solaris ?

dcd_at_noos.fr (aarg) wrote in
news:36bba7a.0504120629.2d2fe1f_at_posting.google.com:

> Hello,
>
> I'm trying to find the memory size of some oracle instance .
> With aix i do this with svmon + ipcs .
>
> The Solaris equivalent to svmon seems to be pmap, so the logics seemed
> to be
> similar.
>
> But when i run the ipcs -mA command, it shows no shared memory for
> oracle. Some shared memory is shown, but none for the oracle user !
>
> What does it means ? Is the size of memory segments as shown with pmap
> displaying the total reserved size for that segment ? Why is there no
> trace of oracle with ipcs ?
>
> Also AIX has an option to ipcs ( -S ) that will show the list of
> Segment ID attached to a shared memory id. This way you can track back
> shared memory information to VSID and in turn to PID . This is usefull
> because the sized shown for a VSID of shared mem is the in-use size
> and
> with ipcs you can see the max reserved size, therefore aproaching the
> corect maximum memory size for an instance .
>
> Does someone knows how to do this with Solaris ? Do you know of other
> ways to compute the memory size of a given oracle instance from within
> Unix ?
>
> The setup is Solaris 5.8 and Oracle 9 . It should be noted that i'm
> not
> root on the server, but i don't think that would change anything to
> the
> ipcs output.
>
> Thanks a lot if anyone can help or provide me pointers to info ,
>
> Regards,
>
> Dav'
>

If the Oracle database is not open for business, then # ipcs -a
won't show any shared memory being used by Oracle. Received on Tue Apr 12 2005 - 09:54:17 CDT