Home » Server Options » Streams & AQ » Contention in stream apply process (10.2..0.2)
Contention in stream apply process [message #353071] Fri, 10 October 2008 21:56
Messages: 389
Registered: November 2007
Senior Member
Hi Expert,
In my stream configuration apply process is not appplying
the captured LCR'S.In the trace file I am getting follwing
A001: warning -- apply server 3, sid 365 waiting on user sid 368 for event (sinc
e 0 seconds):
A001: [enq: TX - row lock contention] name|mode=54580006, usn<<16 | slot=60003,
*** 2008-10-10 22:40:55.509
A001: apply server 4 blocked on server 3
A001: [enq: TX - index contention] name|mode=54580004, usn<<16 | slot=90021, seq

What can be the solution of this problem

Varun Punj,
Previous Topic: Do not want to loose any data after Apply process abort
Next Topic: Oracle Streams and impdp
Goto Forum:

Current Time: Fri Jun 14 06:33:25 CDT 2024