_DISTRIBUTED_LOCK_TIMEOUT parameter

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:

1. By changing this parameter, is the impact limited to operations
performed over dblink or if anyone has seen anything different.

2. 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

.

Relevant Pages

  • Re: _DISTRIBUTED_LOCK_TIMEOUT parameter
    ... We are facing a problem with one of our jobs that runs on say database ... this job runs and this job doesn't lock itself out. ... modify/correct it to commit its changes in a more timely manner and ...
    (comp.databases.oracle.server)
  • Re: Parameterization of Object Models
    ... Lock down Access to the system -- ... Attempt to prevent deadlocks see The Concepts of Database Management, ... recovery; that is, you say that you recovered the database. ... database (called a backup or a save). ...
    (comp.lang.misc)
  • Re: Limit FORM mailer submissions to 5 on website, then pause until reviewed by webmaster
    ... have a script that creates a temporary row in a sessions table as soon ... then don't display the input form and instead display the message, ... You wouldn't lock the file from the time they come to the page until ... the database occurs, ...
    (comp.lang.perl.misc)
  • Re: Running Analysis Server 2000 on seperate box
    ... On further investigation regarding the lock up problem. ... the dimension processing running and although the database rows are ... changing the service account sorted things. ... The server has both the database and Analysis Services ...
    (microsoft.public.sqlserver.olap)
  • Re: Command Line for Backing up Source Safe.
    ... If anybody else know of a command line way to lock the database let me know. ... Archive to a backup. ... > @echo off ...
    (microsoft.public.vstudio.sourcesafe)