My Oracle Support Banner

ORA-04030 (callheap,kkpamkP_kkpam kkpamLDInit) Error Inserting Into Subpartitioned Table (Doc ID 1535567.1)

Last updated on FEBRUARY 22, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.2 and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Cloud Schema Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

  1. An INSERT statement containing a subquery fails with:
    ORA-04030: out of process memory when trying to allocate 2040 bytes (callheap,kkpamkP_kkpam kkpamLDInit)
  2. The INSERT statement looks like:
    INSERT INTO <TABLE_NAME> ( <COLUMN_NAME1>, <COLUMN_NAME2>, <COLUMN_NAME3>, <COLUMN_NAME4>, <COLUMN_NAME5>, <COLUMN_NAME6>, <COLUMN_NAME7>, <COLUMN_NAME8>, <COLUMN_NAME9>, <COLUMN_NAME10>, <COLUMN_NAME11>, <COLUMN_NAME12>, <COLUMN_NAME13>, <COLUMN_NAME14> )
    SELECT /*+ parallel(d, 4) */ D.<COLUMN_NAME1>, D.<COLUMN_NAME2>, D.<COLUMN_NAME3>, D.<COLUMN_NAME4>, D.<COLUMN_NAME5>, D.<COLUMN_NAME6>, D.<COLUMN_NAME7>, D.<COLUMN_NAME8>, D.<COLUMN_NAME9>, D.<COLUMN_NAME10>, D.<COLUMN_NAME11>, D.<COLUMN_NAME12>, D.<COLUMN_NAME13>, D.<COLUMN_NAME14>
    FROM INT_AW_CUSTOMER_PAYPAL D WHERE D.<COLUMN_NAME13> > :B3 AND D.<COLUMN_NAME13> < :B2 AND D.<COLUMN_NAME15> = :B1

Changes

 

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.