Forum Stats

  • 3,740,299 Users
  • 2,248,223 Discussions
  • 7,861,170 Comments

Discussions

ORA-02049: timeout: distributed transaction waiting for lock

user5716448
user5716448 Member Posts: 1,726 Silver Badge

Hi,

version 1.0.2.0.4


Seeing intermittent ORA-02049: timeout: distributed transaction waiting for lock error .


However, when look at the sql see no sign of database link accessing tables so no synonyms or views accessing dblinks.


large insert into a table being run for multiple different branches

e.g insert into table

where branch= branch1


e.g insert into table

where branch= branch2


6 of these branches thus 6 concurrent sqls - inherited system thus don't want to revamp entirely.




when run these serially afterwards o.k.


had thought distributed transaction suggested dblink involved but doesn't seem to be case and dba advised oracle recommedns not increaseing the distributed transaction lock timeout parameter.


Any thoughts?


Thanks

Sign In or Register to comment.