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
varunvir
Messages: 323
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
errors:-
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,
sequence=64f1d
*** 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
uence=65136

What can be the solution of this problem

Regards,
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: Sat Apr 19 12:36:58 CDT 2014

Total time taken to generate the page: 0.10394 seconds