Re: How to identify resources in deadlock graph

From: Giovanni Cuccu <gcuccu_at_dianoema.it>
Date: Wed, 02 Feb 2005 18:12:20 +0100
Message-ID: <420109F4.60403@dianoema.it>

Sorry,

I have a trace file and the two sessions do not exist anymore. I'm wondering if I can extract these information from the trace file. Giovanni

> 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.
>

-- 

----------------------------------------
Giovanni Cuccu
Sw Engineer_at_dianoema.it
Dianoema S.p.A.
Via de' Carracci 93 40131 Bologna
Tel: 051-7098211   051-4193911
e-mail:gcuccu_at_dianoema.it
----------------------------------------
No man does it all by himself,
I said young man,
put your pride on the shelf
----------------------------------------
--
http://www.freelists.org/webpage/oracle-l

Received on Wed Feb 02 2005 - 12:15:32 CST