Saturday, April 21, 2018

ORA-01341: LogMiner out-of-memory

ORA-01280: Fatal LogMiner Error.
ORA-01341: LogMiner out-of-memory



Solution :  

Increase size of below parameter to fix error.

exec dbms_capture_adm.stop_capture(‘CAPTURE_NAME’);
exec dbms_capture_adm.set_parameter(‘CAPTURE_NAME’,’_SGA_SIZE’,’50’);
exec dbms_capture_adm.start_capture(‘CAPTURE_NAME’);
The above changes space for named capture process : 'CAPTURE_NAME'  from  10M -> 50M

Note: If you change the value of the hidden capture parameter _SGA_SIZE, 
then you should also increase the streams_pool_size (10.1 and above) correspondingly. 
For 9.2, increase the shared_pool parameter correspondingly.

No comments:

Post a Comment