Re: Strange Memory Information on AWR
- From: David Barbour <david.barbour1@xxxxxxxxx>
- To: Andrew Kerber <andrew.kerber@xxxxxxxxx>
- Date: Tue, 22 Oct 2013 15:42:50 -0500
Andrew,
pga_aggregate_target is just that, a target. There are a couple of
different ways space pressure on the pga is handled depending on your
version of Oracle, whether or not you are using AMM or ASMM, whether or not
you're using shared or dedicated server, whether or not the wind is blowing
from the Southwest, and probably (as is usually the case with Oracle) a
couple of other parameters as well.
Anyway, you can exceed the target. Try looking at v$pgastat and see if you
have an overallocation count. A quick search of Google has a bunch of
articles, but you might want to try MOS or Tahiti for a more definitive
answer.
On Tue, Oct 22, 2013 at 1:37 PM, Andrew Kerber <andrew.kerber@xxxxxxxxx>wrote:
> Can anyone explain to me what is happening here? The CPU on this node went
> crazy last night, load average went over 200, and we had to restart the
> server. Looking at the AWR report, I see PGA memory usage that makes no
> sense to me. PGA_AGGREGATE_TARGET is set to 6g, but the Memory Statistics
> show a PGA usage of 19G at end, but there is no pga overallocation
> indicated. I cannot figure out what this means. Any idea:
> Memory Statistics
> ~~~~~~~~~~~~~~~~~ Begin End
> Host Mem (MB): 63,320.4 63,320.4
> SGA use (MB): 48,000.0 48,000.0
> PGA use (MB): 1,010.6 19,490.9
> % Host Mem used for SGA+PGA: 77.40 106.59
>
>
> PGA Memory Advisory DB/Inst: CDSP/cdsp Snap:
> 43018
> -> When using Auto Memory Mgmt, minimally choose a pga_aggregate_target
> value
> where Estd PGA Overalloc Count is 0
>
>
> Estd Extra Estd P Estd PGA
> PGA Target Size W/A MB W/A MB Read/ Cache Overallo
> Estd
> Est (MB) Factr Processed Written to Disk Hit % Count
> Time
> ---------- ------- ---------------- ---------------- ------ --------
> -------
> 768 0.1 1,208,422.4 880,557.3 58.0 921
> 1.1E+10
> 1,536 0.3 1,208,422.4 535,859.7 69.0 24
> 9.0E+09
> 3,072 0.5 1,208,422.4 425,651.4 74.0 0
> 8.5E+09
> 4,608 0.8 1,208,422.4 348,331.7 78.0 0
> 8.1E+09
> 6,144 1.0 1,208,422.4 182,790.7 87.0 0
> 7.2E+09
> 7,373 1.2 1,208,422.4 132,664.4 90.0 0
> 6.9E+09
> 8,602 1.4 1,208,422.4 132,542.1 90.0 0
> 6.9E+09
> 9,830 1.6 1,208,422.4 132,302.7 90.0 0
> 6.9E+09
> 11,059 1.8 1,208,422.4 132,269.4 90.0 0
> 6.9E+09
> 12,288 2.0 1,208,422.4 131,837.9 90.0 0
> 6.9E+09
> 18,432 3.0 1,208,422.4 130,749.5 90.0 0
> 6.9E+09
> 24,576 4.0 1,208,422.4 129,604.8 90.0 0
> 6.9E+09
> 36,864 6.0 1,208,422.4 118,194.8 91.0 0
> 6.9E+09
> 49,152 8.0 1,208,422.4 114,471.3 91.0 0
> 6.8E+09
>
>
>
> --
> Andrew W. Kerber
>
> 'If at first you dont succeed, dont take up skydiving.'
>
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
