Home » SQL & PL/SQL » SQL & PL/SQL » Deadlock (Oracle 9.2.0.3)
Deadlock [message #405537] Thu, 28 May 2009 05:09 Go to next message
prachij593
Messages: 266
Registered: May 2009
Senior Member
When a deadlock occurs what are the things to look into?
From which table I can get more information?
Re: Deadlock [message #405539 is a reply to message #405537] Thu, 28 May 2009 05:13 Go to previous messageGo to next message
cookiemonster
Messages: 12410
Registered: September 2008
Location: Rainy Manchester
Senior Member
have a look in the alert log
Re: Deadlock [message #405541 is a reply to message #405537] Thu, 28 May 2009 05:41 Go to previous message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Do you mean a proper deadlock, where one of the sessions gets forcibly rolled back and gets an error message displayed, or do you just mean that a session is waiting on a lock?

If it's the latter, look at dba_blockers and v$global_blocked_locks.
Previous Topic: Oracle 10g : problem order of row in a select request
Next Topic: Procedure failing-Need to know where?
Goto Forum:
  


Current Time: Wed Dec 07 06:38:36 CST 2016

Total time taken to generate the page: 0.16038 seconds