Wednesday, February 29, 2012

Tracking Down Oracle Deadlocks

The Dreaded ORA-00060 error. DEADLOCK DETECTED Fortunately this is not an Oracle problem, but is an application problem. Now the fun part of tracking it down.

1. Locate the Trace file so you can gather some details.

2. Find the resource names in the Trace file…

Resource Name        

Hopefully this will give you some relavant object information. This will allow you to query the all_objects table looking for the objects.

3. Query the all_objects table

select object_name, object_type from all_objects
where object_id in ( to_number( '14ef4', 'xxxxx' ), to_number( '14ef4', 'xxxxx' ) );

From here you get to do some more digging. The trace file will contain a lot of information, mostly cryptic but hopefully it can help point you in the right direction.


Post a Comment