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
===================================================
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
===================================================