Home » RDBMS Server » Server Administration » ORA-02049: timeout: distributed transaction waiting for lock
ORA-02049: timeout: distributed transaction waiting for lock [message #333922] Mon, 14 July 2008 21:54 Go to next message
caprikar
Messages: 226
Registered: March 2007
Senior Member
Hi,
Our users are complianing that they had an timeout with distributed tracsation waiting for lock approximately 6 hours ago. Is there anyway i can find is there really a distributed transaction lock, if so how to find more information like which query, user was causing that lock. We have three node RAC oracle 10g running in HP UX.

Report message to a moderator

Re: ORA-02049: timeout: distributed transaction waiting for lock [message #333935 is a reply to message #333922] Mon, 14 July 2008 22:49 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
For RAC look into gv$views.
In this case, gv$lock/gv$session..

Report message to a moderator

Previous Topic: ORA-01078: failure in processing system parameters
Next Topic: How can I change character set of existing Oracle DB (11g)
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Aug 07 00:45:25 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.