Capture logminer process very slow [message #565394] |
Tue, 04 September 2012 04:11 |
|
sevenx
Messages: 1 Registered: September 2012 Location: Bucharest
|
Junior Member |
|
|
Hi,
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.
Both source and destination is 10.2.0.4.
Thanks,
MC
[Updated on: Tue, 04 September 2012 04:57] Report message to a moderator
|
|
|