Capture logminer process very slow http://www.orafaq.com/forum/./mv/msg/183796/565394/#msg_565394
I have a problem with logminer process on my streams downstream database.
There was a long transaction (~80000) that involved 3 columns of blob on source database. In alert log there was an long running transaction detected....in this time the capture process was stopped voluntary and restarted. After that all archive log minings are very slow....for example one of them that initially was minned in 2 minutes now need more than 60 minutes .
Any idea will be appreciated.