RE: Memory usage by an Oracle instance

Peter & List,

This is probably one of the most misunderstood parts of ps... Take a look at MetaClunk note 174555.1.

John Kanagaraj
Oracle Applications DBA
DBSoft Inc
(W): 408-970-7002

The manuals for Oracle are here: http://tahiti.oracle.com The manual for Life is here: http://www.gospelcom.net

• The opinions and statements above are entirely my own and not those of my employer or clients **

> -----Original Message-----
> From: Schauss, Peter [mailto:SCHAUPE_at_mail.northgrum.com]
> Sent: Tuesday, May 21, 2002 1:59 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Memory usage by an Oracle instance
>
>
> Looking at the output from the ps command on AIX I see
> that each of the Oracle background processes, user processes
> and the lgwr, dbw0, pmon, reco, ckpt ... is listed as using
> about 30 mb of memory (based on the SZ column.
>
> 1. Does this value represent both data and code?
> 2. Is there any way to determine how much (if any) of the
> memory listed here is in the form of shared libraries or
> shared memory segments?
>
> Peter Schauss
> Northrop Grumman Corporation
> schaupe_at_mail.northgrum.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Schauss, Peter
> INET: SCHAUPE_at_mail.northgrum.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).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: John Kanagaraj
  INET: john.kanagaraj_at_hds.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).