oracle deadlock ORA-00060: deadlock detected while waiting for resource

757n453llq

today, app raise one database deadlock, from googleed, it said it is my app design issue.

keep trace log as backup. trying to solve it.

SQL> select object_name from dba_objects where object_id=57327;

OBJECT_NAME
--------------------------------------------------------------------------------
NECOMPONENTENTITY



Deadlock graph:
                       ---------Blocker(s)--------  ---------Waiter(s)---------
Resource Name          process session holds waits  process session holds waits
TM-0000dfef-00000000       148     242    SX             89    1069    SX   SSX
TX-000a0011-00002f93        89    1069     X            148     242           X

session 242: DID 0001-0094-00000002     session 1069: DID 0001-0059-00000002
session 1069: DID 0001-0059-00000002    session 242: DID 0001-0094-00000002

Rows waited on:
  Session 242: obj - rowid = 0000DFEF - AAAN/vAAJAAACtxABV
  (dictionary objn - 57327, file - 9, block - 11121, slot - 85)
  Session 1069: no row

----- Information for the OTHER waiting sessions -----
Session 1069:
  sid: 1069 ser: 1 audsid: 302357 user: 69/SA
    flags: (0x45) USR/- flags_idl: (0x1) BSY/-/-/-/-/-
    flags2: (0x40009) -/-/INC
  pid: 89 O/S info: user: oracle, term: UNKNOWN, ospid: 10889
    image: oracle@A15-fm-1
  client details:
    O/S info: user: , term: , ospid: 1234
    machine: A15-fm-1 program:
  current SQL:
  delete from V00_00_00.NodeInfoBase where m_nodeId=:1

----- End of information for the OTHER waiting sessions -----

Information for THIS session:

----- Current SQL Statement for this session (sql_id=cwu2js263cgt9) -----
update V00_00_00.NEComponentEntity set componentIndex=:1, componentType=:2, m_nodeId=:3, accessControlDataStatus=:4, accessControlSignalingStatus=:5, administrativeState=:6, alarmStatus=:7, cellBarring=:8, componentName=:9, ecgi=:10, oneXACBarringProfile=:11, operationalState=:12, PARENT_NODE_ID=:13, unknownStatus=:14 where componentId=:15
===================================================