Hi All,

I am getting dead lock error often. If I check I got the following transactions

TX-00040029-000e6772
TX-000a001b-000588b2

select object_id,owner, object_name from all_objects
where object_id in ( to_number( '0029', 'xxxx' ), to_number( '001b', 'xxxx' ) );

object_id,owner, object_name
27,SYS,I_COBJ#
41,SYS,I_USER1

How do I find exactly which objects are casuing this error?

Regards,
Sree


DISCLAIMER:
This email (including any attachments) is intended for the sole use of the intended recipient/s and may contain material that is CONFIDENTIAL AND PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying or distribution or forwarding of any or all of the contents in this message is STRICTLY PROHIBITED. If you are not the intended recipient, please contact the sender by email and delete all copies; your cooperation in this regard is appreciated.

Oracle LazyDBA home page