ORA-04030 (KXS-HEAP-W,KNTXSLT.CLEARTEXTARRAY 1) When Refreshing Materialized View (Doc ID 1400389.1)

Last updated on FEBRUARY 01, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 to 11.2.0.3 [Release 11.2]
Information in this document applies to any platform.

Symptoms

When refreshing a materialized view with a materialized view log (MLOG) attached to it, the following error is raised:

ORA-04030: out of process memory when trying to allocate 328 bytes (kxs-heap-w,kntxslt.cleartextarray 1)


The trace file generated during the time of the error , shows the memory chunk "kntxslt.cleartextarray 1 " is over allocated , i.e in below section , its has occupied nearly 91% with size grown to nearly 3.6G

========= Dump for incident 67627 (ORA-4030) ========
----- Beginning of Customized Incident Dump(s) -----
=======================================
TOP 10 MEMORY USES FOR THIS PROCESS
---------------------------------------

*** 2011-08-03 19:24:04.862
91% 3704 MB, 10787884 chunks: "kntxslt.cleartextarray 1 "  SQL kxs-heap-w ds=0x2b2b26bd81f8 dsprt=0x2b2b269c6d30
6% 229 MB, 65421 chunks: "free memory " session heap ds=0x2b2b269c6d30 dsprt=0xb7fda40
3% 112 MB, 976598 chunks: "free memory " SQL kxs-heap-w ds=0x2b2b26bd81f8 dsprt=0x2b2b269c6d30

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