Session PGA Consuming Large Amount of 'kolarsCreateCt' Memory

(Doc ID 1936043.1)

Last updated on NOVEMBER 10, 2014

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.3 and later
Information in this document applies to any platform.

Symptoms

When LOBs are stored in Securefiles the customer sees ORA-4030 signaled with high allocations of kolarsCreateCt memory. The trace written by the ORA-4030 error

has output similar to:

 

TOP 10 MEMORY USES FOR THIS PROCESS
---------------------------------------
61% 4980 MB, 260787 chunks: "permanent memory          "  
         kolarsCreateCt  ds=0x7f454bea3558  dsprt=0x7f474c513c18
37% 2980 MB, 53078 chunks: "free memory               "  
         top uga heap    ds=0xbb82820  dsprt=(nil)
 1%   84 MB, 110323 chunks: "free memory               "  
         kolarsCreateCt  ds=0x7f454bea36b8  dsprt=0x7f474c513c18

 

Patches for unpublished bug 14582843 and <bug 16382883> are already applied.

Changes

 Changing to securefiles from basicfiles

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