Message-ID: <F001.005D653E.20031111043503@fatcity.com>
Date: Tue, 11 Nov 2003 04:35:03 -0800
To: Multiple recipients of list ORACLE-L <ORACLE-L@fatcity.com>
Sender: ml-errors@fatcity.com
Reply-To: ORACLE-L@fatcity.com
Errors-To: ML-ERRORS@fatcity.com
From: "Richard Foote" <richard.foote@bigpond.com>
Subject: Re: Memory consumption on HP-UX
Organization: Fat City Network Services, San Diego, California
Precedence: bulk
Mime-Version: 1.0
Content-Type: text/plain;	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

Hi Helmut,

Notice the parameter is called pga_aggregate_TARGET and not
pga_aggregate_MAX_SIZE.

That's because the P_A_T is just that, a target the Oracle does it's best to
not exceed. It does this by controlling and rationing the "tuneable"
component of the PGA (ie. those portions of the PGA previously controlled by
the *_AREA_SIZE parameters) on a as need/on demand basis based on current
system load.

However, if the number of sessions/processes is such that the other
"non-tuneable" components of the PGAs were to put pressure on the P_A_T,
then Oracle may have no choice but to exceed it. This is not a good thing in
that obviously more PGA memory is allocated that you ideally want and also
because the workarea operations are not going to be the ideal optimal
executions you're after. Increasing the P_A_T would be therefore be
recommended, depending of course on your available memory.

v$pgastat, v$pga_target_advice and v$process will give you useful info on
how much you may have exceeded your P_A_T.

Cheers

Richard


----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <ORACLE-L@fatcity.com>
Sent: Tuesday, November 11, 2003 7:54 PM


> 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@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@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.net
-- 
Author: Richard Foote
  INET: richard.foote@bigpond.com

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@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).