Strange Memory Information on AWR

From: Andrew Kerber <andrew.kerber_at_gmail.com>
Date: Tue, 22 Oct 2013 13:37:58 -0500
Message-ID: <CAJvnOJaaRGZpwYQff611-ZDp8U_pOdwORf6=F9UfrFubDhc8vg_at_mail.gmail.com>

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


--
http://www.freelists.org/webpage/oracle-l

Received on Tue Oct 22 2013 - 20:37:58 CEST