ORA-04030 A Direct Load Into Many Partitions With Huge Allocation Request From "KLLCQGF:KLLSLTBA" (Doc ID 1578849.1)

Last updated on AUGUST 23, 2013

Applies to:

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

Symptoms

A direct load into many partitions fails with error ORA-04030 (klcliti:kghds,kllcqgf:kllsltba):

Create table bugtable partition by range(BSNSS_UNIT_ID)
interval(100)
subpartition by hash(PYMNT_SPNSR_ID)
subpartitions 32
(partition p0 values less than (438947)) nologging as
Select * from scott.bsnss_acfs;

create table bugtable partition by range(BSNSS_UNIT_ID)
*
ERROR at line 1:
ORA-4030: out of process memory when trying to allocate 266264 bytes (klcliti:kghds,kllcqgf:kllsltba)

Trace file shows following information and stack trace:


DIAGNOSTIC ANALYSIS:
--------------------
TOP 10 MEMORY USES FOR THIS PROCESS
---------------------------------------
...
79% 12 GB, 49377 chunks: "kllcqgf:kllsltba "
klcliti:kghds ds=0x2ab13a35bd38 dsprt=0xae8ac40

...

kghnospc kghalf klmalf kdblalp kllcqgf kcblnb_dscn kdblnb kdblgb kdblailb kdblai
kdblloadspill kdblcmtt klclisync qerltFetch ctcdrv

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