Memory consumption on HP-UX

From: Daiminger, Helmut <HELMUT.DAIMINGER_at_wwk.de>
Date: Tue, 11 Nov 2003 01:54:26 -0800
Message-ID: <F001.005D63F1.20031111015426@fatcity.com>

Hi,

how do I find out how much memory Oracle uses on an HP-UX box?

Finding the shared memory portion (i.e. SGA) is fairly easy...

But how do I find out how much memory each dedicated user process is consuming?

Or is the rule of thumb like this: no matter whether you have 10 or 500 users, the memory consumed by the user processes will never exceed pg_aggregate_target?

This would mean that the maximum memory consumption is SGA + PGA_AGGREGATE_TARGET. No matter how many users are on the system (of course you would size PGA_aggregate_target accordingly beforehand).

This is 9.2 on HP-UX 11.

Thanks,
Helmut
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Daiminger, Helmut
  INET: HELMUT.DAIMINGER_at_wwk.de

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

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). Received on Tue Nov 11 2003 - 03:54:26 CST