investigating deadlocks - wait-for-graph
From: D'Hooge Freek <Freek.DHooge_at_uptime.be>
Date: Thu, 25 Nov 2010 17:56:55 +0100
Message-ID: <4814386347E41145AAE79139EAA398981039AABBD9_at_ws03-exch07.iconos.be>
Hi,
Date: Thu, 25 Nov 2010 17:56:55 +0100
Message-ID: <4814386347E41145AAE79139EAA398981039AABBD9_at_ws03-exch07.iconos.be>
Hi,
I have a rac database (10.2.0.4 on Redhat linux 4.6), which reports daily 5 or 6 times a global enqueue deadlock detected.
For my investigations I'm trying to understand the wait-for-graph, but information seems to be limited.
Global Wait-For-Graph(WFG) at ddTS[0.1062] :
BLOCKED 0x1d4929550 5 wq 2 cvtops x1 [0x1c001b][0x19644],[TX] [4A000-0001-00000D8A] 0 BLOCKER 0x1b81f25d0 5 wq 1 cvtops x8 [0x1c001b][0x19644],[TX] [B3000-0002-00000C60] 1 BLOCKED 0x1d4ac8e00 5 wq 2 cvtops x1 [0x20028][0x48c3e],[TX] [B3000-0002-00000C60] 1 BLOCKER 0x1d48ee550 5 wq 1 cvtops x8 [0x20028][0x48c3e],[TX] [4A000-0001-00000D8A] 0
If my information is correct, the last column is the rac node and the before last is the transaction id.
wq 1 is the grant queue and wq 2 is the convert queue.
But what is the second and third column (lock mode?) And what about the other fields?
Any pointers?
Kind regards,
Freek D'Hooge
Uptime
Oracle Database Administrator
email: freek.dhooge_at_uptime.be
tel +32(0)3 451 23 82
http://www.uptime.be
disclaimer: www.uptime.be/disclaimer
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Nov 25 2010 - 10:56:55 CST