OraFAQ Forum: Server Administration » ORA-02049: timeout: distributed transaction waiting for lock

Home » RDBMS Server » Server Administration » ORA-02049: timeout: distributed transaction waiting for lock

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-02049: timeout: distributed transaction waiting for lock [message #52776]

Tue, 13 August 2002 03:24

rajesh
Messages: 173
Registered: November 1998

Senior Member

hi
We are working on a MTS environment. While using sql loader, we are getting this error
ORA-02049: timeout: distributed transaction waiting for lock
Can we set the
_distributed_lock_timeout parameter in the init.ora file?
Will this solve the problem?
This is urgent

Report message to a moderator

Re: ORA-02049: timeout: distributed transaction waiting for lock [message #52778 is a reply to message #52776]

Tue, 13 August 2002 04:53

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

In few cases, Just increasing the parameter value has not solved the issue.
You may need to consider the databases for any EXCLUSIVE locks held on the table(s) involved. Query the V$LOCK view.

Report message to a moderator

Previous Topic:	Re: how do i know what oracle patches implemented on database
Next Topic:	connection problem on client side

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 19 21:54:03 CDT 2024