Re: How to identify resources in deadlock graph
- From: Giovanni Cuccu <gcuccu@xxxxxxxxxxx>
- To: Mladen Gogala <mgogala@xxxxxxxxxxxxxxxxxxxx>
- Date: Wed, 02 Feb 2005 18:12:20 +0100
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@xxxxxxxxxxx
Dianoema S.p.A.
Via de' Carracci 93 40131 Bologna
Tel: 051-7098211 051-4193911
e-mail:gcuccu@xxxxxxxxxxx
----------------------------------------
No man does it all by himself,
I said young man,
put your pride on the shelf
----------------------------------------
--
//www.freelists.org/webpage/oracle-l
Other related posts:
