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

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
===================================================
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值