| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Memory consumption on HP-UX
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
> 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).Received on Tue Nov 11 2003 - 09:14:25 CST
 |
 |