Wednesday, October 14, 2015

Oracle Streams & CDC 11gR2 - ORA-01341: LogMiner out-of-memory

The ORA-01341: LogMiner out-of-memory occurs when LogMiner session is out of memory and causes the Capture Process to abort.

The problem is often encountered after the database was upgraded to 11.2.0.3

This means that the Capture Process needs to be configured internally to have more memory space:

1. Find the capture name:

select capture_name from dba_capture;

CAPTURE_NAME                 
------------------------------
MYCAPTURE      

2. Stop capture , set the new size and start the capture

exec dbms_capture_adm.stop_capture('MYCAPTURE');
exec dbms_capture_adm.set_parameter('MYCAPTURE','_SGA_SIZE','80');
exec dbms_capture_adm.start_capture('MYCAPTURE');

The default size of space for capture / log miner activity is 10 M. A value for 80M - 150M should be sufficient , but can be increased even more.


If you have this error frequently then you may have hit BUG 16747736 LogMiner memory leak witch is fixed on 11.2.3.0.10 PSU onwards and in 11.2.0.4.



REFERENCES
Oracle support Documents :
1564035.1
16747736.8
335516.1



No comments:

Post a Comment