My Oracle Support Banner

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

Last updated on FEBRUARY 03, 2019

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

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.