My Oracle Support Banner

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

Last updated on SEPTEMBER 29, 2021

Applies to:

Oracle Database - Enterprise Edition - Version and later
Oracle Database Cloud Schema Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Information in this document applies to any platform.


Running Streams/Change Data Capture

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



No changes in the Streams configuration.

The problem is often encountered after the database was upgraded to, 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');


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.