My Oracle Support Banner

Session PGA Consuming Large Amount of 'kolarsCreateCt' Memory (Doc ID 1936043.1)

Last updated on FEBRUARY 18, 2019

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

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.