Seeing ODR_LOB messages in reverse capture/export queue, though no activity happens in target.
Flushing of LOB data occurs when the associated DML is processed. The one exception is if the allocated memory cannot accommodate the cumulative size of all LOB pieces. When this happens all the buffered data is sent to the target.
WORKAROUND
For the messages which are already in the queue you can read release them. These messages are not harmful. They are not DML messages.
You need to increase SP_OCT_LOB_BUFFER size. Default is set at 5M.
You can increase the above parameter based on replicated LOB column size. For a 8k database block size it can be set at 4* (MAX LOB size) replicated.
sp_ctrl>stop capture
sp_ctrl> set param SP_OCT_LOB_BUFFER_SIZE <in bytes>
sp_ctrl> start capture
STATUS
Waiting for fix in a future release of SharePlex.
Applies to versions 4.5 and 5.1 as well
