My Oracle Support Banner

High Memory Utilization Of MMNL Process (Doc ID 2509409.1)

Last updated on OCTOBER 23, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 12.2.0.1 to 19.3.0.0.0 [Release 12.2 to 18]
Information in this document applies to any platform.

Symptoms

Since upgrade to 12.2.0.1, the MMNL process keeps consuming PGA.

From MMNL trace file, the increase in memory is seen in "kgfnConnect2Int hsndef" or "kgfnConnect2Int" structure.

Example from MMNL trace:

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)


A heapdump collected from MMNL trace will look like:

---> 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    "

 

Changes

 Upgrade to 12.2.0.1.

Cause

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

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


In this Document
Symptoms
Changes
Cause
Solution
References


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