Indexing a large set of Documents with CHINESE_LEXER is Slow and Fails with ORA-4030 (Doc ID 1102320.1)

Last updated on MAY 17, 2010

Applies to:

Oracle Text - Version: 10.2.0.4 to 11.2.0.1 - Release: 10.2 to 11.2
Information in this document applies to any platform.

Symptoms

Trying to create a text index using the CHINESE_LEXER on large table is very slow and fails with error ORA-4030:

CREATE INDEX idx_userschool_sname ON Userschool( sname ) INDEXTYPE is ctxsys.context Parameters('lexer chinese_lexer');
*
ERROR at line 1:
ORA-29885: error occurred in the execution of ODVIINDEXCREATE routine
ORA-04030: out of process memory when trying to allocate 66840 bytes(Heap for lexic,gxlmCtor)
ORA-06512: at "CTXSYS.DRUE", line 160
ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 366

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