_DISTRIBUTED_LOCK_TIMEOUT parameter

From: <purohitatul_at_gmail.com>
Date: Fri, 31 Aug 2007 11:34:29 -0700
Message-ID: <1188585269.261824.307790@q5g2000prf.googlegroups.com>

Hi All,

Oracle version: 9.2.0.8
We are facing a problem with one of our jobs that runs on say database db_a and writes on db_b.
Job, at times, aborts giving error "ORA-02049: timeout distributed transaction waiting for lock".
One of the recommendations that came up was to increase DISTRIBUTED_LOCK_TIMEOUT to 7 minutes instead of default 60 secs.

A had a couple of questions on this change and it would be great if anyone can provide pointers:

By changing this parameter, is the impact limited to operations performed over dblink or if anyone has seen anything different.
Any other way that this error can be fixed.

Further whats confusing is no other query is locking the table when this job runs and this job doesn't lock itself out.

Thanks,
Atul Received on Fri Aug 31 2007 - 13:34:29 CDT