Re: investigating deadlocks - wait-for-graph

> 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


      
--
http://www.freelists.org/webpage/oracle-l

Other related posts: