My Oracle Support Banner

MMNL进程占用内存高 (Doc ID 2577519.1)

Last updated on AUGUST 21, 2019

适用于:

Oracle Database - Enterprise Edition - 版本 12.2.0.1 到 19.3.0.0.0 [发行版 12.2 到 18]
本文档所含信息适用于所有平台

症状

自升级到12.2.0.1以来,MMNL进程使用的PGA一直在增长。
从MMNL跟踪文件中,可以看到“kgfnConnect2Int hsndef”或“kgfnConnect2Int”相关的内存使用较多。
MMNL跟踪示例:

30%   53 MB, 2785 chunks: "kgfnConnect2Int hsndef    "  
         pga heap        ds=0x7f1bdcfa2260  dsprt=(nil)

30%   53 MB, 2785 chunks: "kgfnConnect2Int hsndef    "  
         pga heap        ds=0x7f1bdcfa2260  dsprt=(nil)


MMNL收集的heapdump跟踪文件如下所示:

---> HEAP DUMP heap name="pga heap"  desc=0x7f3e7ffe8260
               Type           Count             Sum         Average
               ~~~~           ~~~~~             ~~~         ~~~~~~~
               perm            3193       187871832        58838.66

BreakDown
~~~~~~~~~
     Type           Count             Sum         Average
     ~~~           ~~~~~             ~~~        ~~~~~~~ ~~~~~~~
     perm          3193       187871832       58838.66  91.11

Total = 206211288 bytes       201378.21k          196.66MB

Breakdown of CPRM Chunks (Commented Perm Chunks)

              Type           Count             Sum         Average
              ~~~~           ~~~~~             ~~~         ~~~~~~~
   kgfnConnect2Int            7992       159392448        19944.00

   Chunk     7f3e6b959020 sz=    65504    perm      "perm           "  
alo=39944
13304             7f3e6b959048 sz=    19944    cprm      "kgfnConnect2Int"
13305             7f3e6b95de30 sz=    19944    cprm      "kgfnConnect2Int"
13306             7f3e6b962c18 sz=       16    cprm      "CPM trailer    "

 

更改

 升级到12.2.0.1.

原因

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


文档内容
症状
更改
原因
解决方案
参考

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.