Oracle deadlock dumps
23 July 2002 02:00

>In Oracle deadlock dumps, you'll notice the two lines containign strings looking like: TM-000042f5-00000000. Well, the middle number in that string is the hexadecimal value for the object id of the object in question (i.e., the one the transaction is trying to lock). So just convert the number to decimal, and then do SELECT object_name, object_type FROM dba_objects WHERE object_id=;