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