Home » RDBMS Server » Server Administration » ORA-00060: deadlock detected while waiting for resource (Oracle 11.2.0.3, Linux x86 64)
ORA-00060: deadlock detected while waiting for resource [message #626558] Wed, 29 October 2014 02:39 Go to next message
hitesh.bhatt
Messages: 84
Registered: February 2014
Location: INDIA
Member
Hi,

Can anyone please help me understand this deadlock graph?
Many Thanks in advance.
Deadlock graph:
                       ---------Blocker(s)--------  ---------Waiter(s)---------
Resource Name          process session holds waits  process session holds waits
TX-0008002b-00160521        93     867     X             84     717           S
TM-00004bcf-00000000        84     717    SX             71    1224         SSX
TM-00004bcf-00000000        71    1224         SSX       90     348          SX
TM-0000abd8-00000000        90     348    SX             59     530    SX   SSX
TM-0000abd8-00000000        59     530    SX   SSX       93     867          SX

[Updated on: Wed, 29 October 2014 03:09] by Moderator

Report message to a moderator

Re: ORA-00060: deadlock detected while waiting for resource [message #626561 is a reply to message #626558] Wed, 29 October 2014 03:15 Go to previous messageGo to next message
John Watson
Messages: 7216
Registered: January 2010
Location: Global Village
Senior Member
I've added [code] tags to your post. Please do so yourself in future.

The first line of that excerpt from the trace file shows that session 867 is blocking session 717. You can follow the problem from line to line. If you look at the rest of the trace file you'll see the current SQLs for each session, which will help you work out why this situation has arisen.
Re: ORA-00060: deadlock detected while waiting for resource [message #626571 is a reply to message #626561] Wed, 29 October 2014 05:13 Go to previous message
hitesh.bhatt
Messages: 84
Registered: February 2014
Location: INDIA
Member
Many Thanks
Previous Topic: Why does a database imported from a production dump not have the same csscan as the original db
Next Topic: ORA-01507: database not mounted
Goto Forum:
  


Current Time: Thu Jan 18 17:05:39 CST 2018

Total time taken to generate the page: 0.01698 seconds