ORA-04030 Out Of Memory Allocation Errors During Crawling (Doc ID 1123991.1)

Last updated on FEBRUARY 11, 2017

Applies to:

Oracle Secure Enterprise Search - Version 10.1.8.2 to 11.1.2.2
Microsoft Windows (32-bit)
Microsoft Windows x64 (64-bit)
***Checked for relevance on 19-August-2014***

Symptoms

Crawling a database source gives ORA-04030 out of memory errors.

The following errors are seen in the crawler logs


last few lines of the crawler logs:
ORA-06512: at "EQSYS.EQ_TASK", line 533
ORA-04030: out of process memory when trying to allocate 40972 bytes (koh-kghu call ,pefduralc)
ORA-06512: at "EQSYS.EQ_ERR", line 10
ORA-06512: at "EQSYS.EQ_ERR", line 60
ORA-06512: at "EQSYS.EQ_ERR", line 78
ORA-06512: at "EQSYS.EQ_INDEX", line 89
ORA-04030: out of process memory when trying to allocate 27984 bytes



The following has been done to attempt to resolve the condition:

(1) Reduced the Crawler threads into 1 for respective source.
(2) Reduced the Indexing Batch Size to 50 Mb
(3) Reduced the Indexing Memory Size to 100 Mb
(4) Increased the SGA of the SES database instance
(5) Changed the Index optimization to REBUILD with following job:


set serveroutput on
DECLARE
jobno NUMBER;
BEGIN
SYS.DBMS_JOB.SUBMIT
(
job => jobno
,what => 'begin
ctx_output.start_log(''rebuild_opt.txt'');
ctx_ddl.optimize_index(''eq_test.eq$doc_path_idx'',''rebuild'');
ctx_output.end_log;
end;'
,next_date => to_date('03/11/2009 20:07:00','mm/dd/yyyy hh24:mi:ss')
,no_parse => FALSE
);
dbms_output.put_line( jobno);
END;



(6) Changed the Schedule to be Daily instead of Hourly to reduce db buffer
cache usage.

However the problem persists. The following errors are seen in the database trace files:

last few lines of trc file:
ORA-06512: at "EQSYS.EQ_INDEX", line 89
ORA-04030: out of process memory when trying to allocate 8192 bytes (sort subheap,sort key)
ORA-04030: out of process memory when trying to allocate 38928 bytes (droinst:prm he,drepkla:node)

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