Streams Apply Servers self-deadlocking
Date: Thu, 06 Nov 2008 08:56:16 +0000
this is quite a specific question about streams ....
My source database produces too many LCRs for the destination database to keep up with (flow control kicking in, capture-to-apply lag is quite high). So I thought I'd increase the parallelism of my apply but this causes my a big headache: after 15 mins at most, the apply process aborts (abort on error is true) because of a deadlock caused by my 2 streams apply servers (AS03 and AS06). Checking dba_apply_error clearly indicates an ORA-60 as the cause for the apply to abort.
It's not a severe problem as I can easily rerun the transaction and restart the apply but still I'd rather solve this problem.
My question: did anybody experience the same problem with 2 parallel apply servers? If so, how did you fix it?
Source and destination run on 32bit RHEL5u1, destination database is 126.96.36.199
Thanks for any suggestions!
MartinReceived on Thu Nov 06 2008 - 02:56:16 CST