ORA-01280: Fatal LogMiner Error.
ORA-01341: LogMiner out-of-memory
Solution :
Increase size of below parameter to fix 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’);
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.
For 9.2, increase the shared_pool parameter correspondingly.
No comments:
Post a Comment