Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: How to identify resources in deadlock graph
Giovanni Cuccu wrote:
>
>The problem is on session 52, I have identified the object_id which
>corresponds to 1700 hex, but I'm not able to determine the other resource in the deadlock graph.
>
>
V$SESSION table contains the column named ROW_WAIT_OBJ# which can be joined
to DBA objects.
-- Mladen Gogala Oracle DBA Ext. 121 -- http://www.freelists.org/webpage/oracle-lReceived on Wed Feb 02 2005 - 12:13:21 CST