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 laterOracle 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
- An INSERT statement containing a subquery fails with:
ORA-04030: out of process memory when trying to allocate 2040 bytes (callheap,kkpamkP_kkpam kkpamLDInit) - 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 |