My Oracle Support Banner

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

Last updated on AUGUST 04, 2018

Applies to:

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


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) -----

*** 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


To view full details, 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 a vibrant support community of peers and Oracle experts.