ORA-02049: timeout: distributed transaction waiting for lock

user5716448

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