Re: investigating deadlocks - wait-for-graph
- From: Yong Huang <yong321@xxxxxxxxx>
- To: Freek.DHooge@xxxxxxxxx
- Date: Sat, 27 Nov 2010 07:25:58 -0800 (PST)
> BLOCKED 0x1d4929550 5 wq 2 cvtops x1 [0x1c001b][0x19644],[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?
Adding to what Rui said, the lock mode, 5 here, is actually exclusive
instead of shared/row exclusive, or 6 in our normal lock mode numbering.
In RAC deadlock graph, the mode starts with 0 for some reason. See
section "Deadlocks in RAC" of
http://yong321.freeshell.org/computer/deadlocks.txt
In addition, the hex numbers following "BLOCKED" or "BLOCKER"
are handles (lock pointers) of v$ges_blocking_enqueue. I wrote the
note about 9i RAC. The old items in the graph still exist, just with
more in newer versions.
Yong Huang
--
//www.freelists.org/webpage/oracle-l
Other related posts:
