Low target throughout (Oracle to SQL Server): Outoing stream is full.
Hi,
I have a replicate task which replicate data betwen Oracle (with Attunity Log Reader through ASM) and to a Microsoft SQL Server instance. The source contains a lot of LOBS. Unfortunately my target throughput is really low (200-300 kb/s). If i'm replicating to a target file instance instead the throughput if 6k - 33k and the LOB data is there.
Going through the low i constantly see the message 'Outgoing stream is full. Forwarding events to target is postponed', which I suspect is the reason for my low throughput? What does this message mean, and how can i configure my outgoing stream buffer?
Outgoing stream is full. Forwarding events to target is postponed
If a transaction is too large to keep in memory or the transaction does not commit for a long time, changes will be stored in the Sorter. Then AR can keep reading changes from the source.Now, your changes are offloaded to the disk (sorter). When AR tries to move the offload changes from sorter to the queue (outgoing stream), it finds that the queue is full. That's why sorter says outgoing stream is full.
If disk I/O or DB is not fast enough, "outgoing stream is full" is likely to happen.
