RE: Oracle memory usage.

Thanks John (and K Gopalakrishnan),

        This detailed White paper has the sort of info I was looking for. - Mike
-----Original Message-----
From: John Kanagaraj [mailto:JKanagaraj_at_mfi.com] Sent: 17 October 2000 18:30
To: M.Jenner_at_southampton.gov.uk
Cc: ORACLE-L_at_fatcity.com; oracledba_at_quickdoc.co.uk Subject: Re: Oracle memory usage.

Mike,

take a look at
http://www.geocities.com/kgkrish/download/vmsizing.pdf (could answer your question...)

John Kanagaraj

Jenner Mike wrote:
>
> 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
> also send the HELP command for other information (like subscribing).
>
> --------
> Think you know someone who can answer the above question? Forward it to
them!
> to unsubscribe, send a blank email to oracledba-unsubscribe_at_LAZYDBA.com
Received on Fri Oct 20 2000 - 08:55:34 CDT