Forum Stats

  • 3,701,596 Users
  • 2,239,431 Discussions
  • 7,835,406 Comments

Discussions

ORA-02049: timeout: distributed transaction waiting for lock

user5716448user5716448 Posts: 1,674 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.