ORA-4030 when creating a Text Index
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.
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).
Getting a heapdump shows memory leak with signature "lobbufSize" and "buf qmudxCtx :" is seen under "koh dur heap d".
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