11.2.0.3.4 Memory Leak Under KGLHD In Shared Pool (Doc ID 1534706.1)

Last updated on JUNE 15, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.3 to 11.2.0.3 [Release 11.2]
Information in this document applies to any platform.

Symptoms

The shared pool was growing out of control and taking RAM from the buffer cache and the database was required to be restarted once per week. High allocation is seen under  KGLHD in shared pool.

Applied Patch 14275572 - 11.2.0.3.4 Patch Set Update that includes the fix for bug 13250244 that is memory leak under KGLHD in shared pool .
But this didn't help and the growth under  KGLHD prevailed.

---> HEAP DUMP heap name="sga heap(4,0)"  desc=0x60073148
             Type           Count             Sum         Average
             ~~~~           ~~~~~             ~~~         ~~~~~~~
             free          956299       307823176          321.89
         recreate         3898863      2426407192          622.34
             perm            6057        26403200         4359.12
         freeable           26536        29199992         1100.39
       R-freeable              79        42652728       539907.95
           R-free              28        27142680       969381.43
            "perm               2               0            0.00

BreakDown
~~~~~~~~~
             Type           Count             Sum         Average Percent
             ~~~~           ~~~~~             ~~~         ~~~~~~~ ~~~~~~~
  Free(heap.awk)           956327       334965856          350.26  11.71
  KGLHD                   3891052      2396150008          615.81  83.79
  KGLH0^5eebdcf3                1            4096         4096.00   0.00
  perm                       6059        26403200         4357.68   0.92
  KGLH0^70c20803                1            4096         4096.00   0.00
  KGLH0^253d4c37                1            4096         4096.00   0.00
  KGLH0^e5092b7f                2            8192         4096.00   0.00

 

Cause

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 hundreds of Community platforms