RE: High Memory Usage
- From: D'Hooge Freek <Freek.DHooge@xxxxxxxxx>
- To: "stalinsk@xxxxxxxxx" <stalinsk@xxxxxxxxx>, oracle-l <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 26 Aug 2011 10:14:52 +0200
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@xxxxxxxxx
tel +32(0)3 451 23 82
http://www.uptime.be
disclaimer: www.uptime.be/disclaimer
---
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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.0
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
Other related posts: