Deadlocks

Hi, how to find the machine name causing deadlock? I mean any Data Dictionary object to view this information.

I have checked the trace file but not able to locate.



thanks,

did you check the alert log? It gives the good information about dead locks but not sure about machine name.

Find the SQL which is causing dead lock then you can find from which machine it is executed.

Thanks,