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.
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: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
For RAC look into gv$views.
In this case, gv$lock/gv$session..
Previous Topic: ORA-01078: failure in processing system parameters
Next Topic: How can I change character set of existing Oracle DB (11g)
Goto Forum:
  


Current Time: Sun Dec 08 05:53:10 CST 2024