OraFAQ Forum: Streams & AQ » Contention in stream apply process

Home » Server Options » Streams & AQ » Contention in stream apply process (10.2..0.2)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Contention in stream apply process [message #353071]

Fri, 10 October 2008 21:56

varunvir
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
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,

Report message to a moderator

Previous Topic:	Do not want to loose any data after Apply process abort
Next Topic:	Oracle Streams and impdp

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Feb 13 01:03:17 CST 2025