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" <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Memory consumption on HP-UX
Use glance if you have that package installed, look for ps -ef | grep midaemon Allan -Original Message- Sent: Tuesday, November 11, 2003 3:54 AM To: Multiple recipients of list ORACLE-L 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). __ This email is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Copying, forwarding or distributing this message by persons or entities other than the addressee is prohibited. If you have received this email in error, please contact the sender immediately and delete the material from any computer. This email may have been monitored for policy compliance. [021216] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nelson, Allan INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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" <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: Memory consumption on HP-UX
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" <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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" <[EMAIL PROTECTED]> > 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: [EMAIL PROTECTED] > > > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > Fat City Net
