Streams Capture Crashes in 11.2.0.3 with Error: ORA-01341: LogMiner Out-of-memory (Doc ID 1564035.1)

Last updated on FEBRUARY 14, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.3 and later
Information in this document applies to any platform.

Symptoms

11.2.0.3

Running Streams/Change Data Capture

Capture/Logminer aborts with error ORA-01341: LogMiner out-of-memory.

 

Changes

No changes in the Streams configuration.

The problem is often encountered after the database was upgraded to 11.2.0.3, it used to work before and now logminer crashes.

As a workaround increasing the capture parameter _SGA_SIZE to a very high value will eventually stop logminer crashing.

exec dbms_capture_adm.set_parameter('<capture_name>','_SGA_SIZE','80');

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