ORA-4030 when creating a Text Index (Doc ID 1086341.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 10.2.0.4 - Release: 10.2 to 10.2
Information in this document applies to any platform.
Issue may happen on both 32-bit and 64-bit platforms.

Symptoms

The problem was first reported on a Windows 32-bit platform.

ORA-4030 is generated when creating a text index.

Indextype is CTXSYS.CONTEXT.

Different memory settings do attempted but it failed every time because of exceeding 2G virtual memory per process limitation.

Same problem has also been reported on 64-bit servers.  Index creation fails when Oracle-process has used 25 Gb of memory (index creation used 15 Gb out of 25 Gb).

Changes

DBMS_XMLGEN.CONVERT returning clob is called in a loop.

Getting a heapdump shows memory leak with signature "lobbufSize"  and  "buf qmudxCtx :" is seen under "koh dur heap d".

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