OraFAQ Forum: Server Administration » ORA-00060: deadlock detected while waiting for resource

Home » RDBMS Server » Server Administration » ORA-00060: deadlock detected while waiting for resource (Oracle 11.2.0.3, Linux x86 64)

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

ORA-00060: deadlock detected while waiting for resource [message #626558]

Wed, 29 October 2014 02:39

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

John Watson
Messages: 8964
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.

Report message to a moderator

Re: ORA-00060: deadlock detected while waiting for resource [message #626571 is a reply to message #626561]

Wed, 29 October 2014 05:13

hitesh.bhatt
Messages: 84
Registered: February 2014
Location: INDIA

Member

Many Thanks

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 08 11:23:06 CST 2025