- 3,715,723 Users
- 2,242,844 Discussions
- 7,845,508 Comments
Forum Stats
Discussions
Categories
- 1 Introduce Yourself!
- 118 Community Feedback - NEW! (No Product Questions)
- 51 General Community Platform Concerns/Kudos/Feedback
- 41 Community Platform Bug Reports
- 60 How Do I? (Community Platform "How to" Questions)
- 12 Where is the...? (Community Platform Locations)
- 9 I'd Like to See... (Community Platform Ideas & Suggestions)
- 64 Personal Document & Blog Archive
- 2 Community Programs
- 2 Get-Togethers
- 66 Certification Community
- 4.7K Certification Community Discussions
- 31 Oracle Certified Master Profiles
- 26 Oracle Database 12c Administrator Certified Master Profiles
- 31 Visual Builder Cloud Service
ORA-02049: timeout: distributed transaction waiting for lock

user5716448
Member Posts: 1,683 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