12.1.0.2
2 Node RAC
Batch job ran overnight, does an insert append into TABLE_1, got a lock on TABLE_2
ORA-04020: deadlock detected while trying to lock object
user.TABLE2
had to remove the append hing from the insert to get it to work. Id usually be checking for unindexed foreign key, however TABLE_1 has no foreign keys and is showing no references unless Im missing something..
Trace file shows single resource deadlock.
Single resource deadlock: blocked by granted enqueue, f 0
Granted global enqueue 0x18461aae58
I should be able to get the object causing lock by getting the resname value
----------resource 0x182357e030----------------------
resname : [0xd7ed6579][0x130f2dca],[LB][ext 0x0,0x0]
but convert the hex value and I get zero rows
select object_name from dba_objects where object_id in to_number('d7ed6579', 'XXXXXXXX');
= no rows returned
Is that correct way of doing it?