RE: Oracle memory usage.

From: Jenner Mike <M.Jenner_at_southampton.gov.uk>
Date: Tue, 17 Oct 2000 17:23:40 +0100
Message-Id: <10652.119498@fatcity.com>

Thanks,

That looks like the command I've always wanted!

ps -efl or /usr/ucb/ps -auxw always shows the memsize including shared stuff but this command enables me to subtract the SGA and other shared area values giving the memory taken by just that process.

Does anyone have any ideas on my second question regarding total memory actively used in Solaris?
It would be handy to verify that we're not reaching max memory usage but because of the way Solaris keeps stuff paged in, it's not easy to track.

Thanks again..
Regards,
Mike.

-----Original Message-----
From: ARUN K C [mailto:arun_k_c_at_hotmail.com] Sent: 17 October 2000 15:57
To: Multiple recipients of list ORACLE-L Subject: Re: Oracle memory usage.

do a pmap on the particular process you will come to know how much memory he

is using
I think you have used this,if not try this out it is in /usr/proc/pmap -x process_id
once you get the pmap subtract the shared_mem and anon from the table you will come to know how much the particular application is using and also use this command /usr/ucb/ps auxw|head this will tell you which is using how much mem and cpu also
I hope this helps

>From: Jenner Mike <M.Jenner_at_southampton.gov.uk>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: Oracle memory usage.
>Date: Tue, 17 Oct 2000 03:30:21 -0800
>
>Hi,
> Does anyone know how to monitor memory usage on Solaris (2.6)?
>Either used/free or for a particular process?
>
>The values given by ps -efl,top include the shared libraries etc and so are
>larger than actual memory required for that process.
>The values given by vmstat reflect the ageing of pages that Solaris manages
>for me but makes it difficult to show how much is used for real.
>
>This has bugged me for ages so I hope someone can help.
>
>Regards,
>Mike Jenner
>Oracle DBA
>
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Jenner Mike
> INET: M.Jenner_at_southampton.gov.uk
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).

Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

Share information about yourself, create your own public profile at http://profiles.msn.com.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: ARUN K C
  INET: arun_k_c_at_hotmail.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may

Received on Tue Oct 17 2000 - 11:23:40 CDT