RE: High Memory Usage
From: D'Hooge Freek <Freek.DHooge_at_uptime.be>
Date: Fri, 26 Aug 2011 10:14:52 +0200
Message-ID: <4814386347E41145AAE79139EAA39898150E4F48A2_at_ws03-exch07.iconos.be>
Hi,
Date: Fri, 26 Aug 2011 10:14:52 +0200
Message-ID: <4814386347E41145AAE79139EAA39898150E4F48A2_at_ws03-exch07.iconos.be>
Hi,
Yes, pga_aggregate_target is kind of a soft limit. For certain memory requests it will have no other option to give memory to the process requesting it.
You can see the current allocation and how many times oracle had to exceed the pga_aggregate_target limit in v$pgastat.
Regards,
Freek D'Hooge
Uptime
Oracle Database Administrator
email: freek.dhooge_at_uptime.be
tel +32(0)3 451 23 82
http://www.uptime.be
disclaimer: www.uptime.be/disclaimer
--- From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Stalin Sent: vrijdag 26 augustus 2011 10:02 To: oracle-l Subject: High Memory Usage All, I'm trying to figure out high memory usage on one of the DB servers we have and wondering if pga_aggregate_target could ever exceed from what's allocated. We have sga_target set to 16G and pga_a_t set to 2G, however from statspack, i see pga usage to be close to 3G. Is that normal. I have posted relevant sections from statspack for reference. Though i see only 59% of total memory being used, vmstat reports 29G being used. Any idea what could be causing it. This node is a dedicated DB server and only one DB runs on it. Memory Statistics Begin End ~~~~~~~~~~~~~~~~~ ------------ ------------ Host Mem (MB): 32,640.0 32,640.0Received on Fri Aug 26 2011 - 03:14:52 CDT
SGA use (MB): 16,315.7 16,315.7
PGA use (MB): 2,854.4 2,981.5
% Host Mem used for SGA+PGA: 58.7 59.1 ------------------------------------------------------------- Instance Activity Stats workarea memory allocated 0 6,043 Statistic Total per Second per Trans --------------------------------- ------------------ -------------- ------------ workarea executions - onepass 0 0.0 0.0 workarea executions - optimal 7,635 2.1 0.0 -- Thanks, Stalin 11gR2, Solaris 10 -- http://www.freelists.org/webpage/oracle-l