Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Memory consumption on HP-UX

Re: Memory consumption on HP-UX

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Tue, 11 Nov 2003 13:09:25 -0800
Message-ID: <F001.005D6579.20031111130925@fatcity.com>


Hi Juan,

We encountered the same problem.

Issue was due to OS being set in "Eager" swapping mode. Support viewed the fact it reserved a massive amount of swap as a "feature".

However, after switching the OS (HP 5.1 TRU64) to "Lazy" swap mode, the problem (as one would hope) disappeared and we haven't looked back. We have about 32G of swap disk doing nothing :)

Cheers

Richard
----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Wednesday, November 12, 2003 1:14 AM

>
> Take care with automatic PGA management.
> We have TNS12500 HPUX err 12 using it because proceses
> RESERVING lots of swap.
>
> We change to manual PGA (we use sort_area_size, etc.)
>
> It was on 9.2.0.1
>
> -----Mensaje original-----
> De: ml-errors_at_fatcity.com [mailto:ml-errors_at_fatcity.com]En nombre de
> Richard Foote
> Enviado el: martes, 11 de noviembre de 2003 13:35
> Para: Multiple recipients of list ORACLE-L
> Asunto: Re: Memory consumption on HP-UX
>
>
> 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_at_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_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).
> >
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Richard Foote
> INET: richard.foote_at_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_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.net
> --
> Author: Juan Miranda
> INET: j.miranda_at_sermatica.es
>
> 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).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Richard Foote
  INET: richard.foote_at_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_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 - 15:09:25 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US