ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 数据库ORA-0060错误

数据库ORA-0060错误

原创 Linux操作系统 作者:wzq609 时间:2013-06-28 09:37:30 0 删除 编辑
发现数据库报ORA-0060的错误,详细如下:
 
Deadlock graph:
                       ---------Blocker(s)--------  ---------Waiter(s)---------
Resource Name          process session holds waits  process session holds waits
TX-00340016-00013066        70     141     X             99      73           S
TX-00100008-00037d10        99      73     X             70     141           S
 
session 141: DID 0001-0046-00000002 session 73: DID 0001-0063-00000002
session 73: DID 0001-0063-00000002 session 141: DID 0001-0046-00000002
 
Rows waited on:
  Session 141: obj - rowid = 00153991 - AAFTmRAAAAAAAAAAAA
  (dictionary objn - 1390993, file - 0, block - 0, slot - 0)
  Session 73: obj - rowid = 00153991 - AAFTmRAAAAAAAAAAAA
  (dictionary objn - 1390993, file - 0, block - 0, slot - 0)
 
----- Information for the OTHER waiting sessions -----
Session 73:
  sid: 73 ser: 11 audsid: 29006 user: 34/SAPSR3
    flags: (0x9000041) USR/- flags_idl: (0x1) BSY/-/-/-/-/-
    flags2: (0x40009) -/-/INC
  pid: 99 O/S info: user: orabip, term: UNKNOWN, ospid: 13107358
    image: oracle@joeonebip
  client details:
    O/S info: user: bipadm, term: , ospid: 9306112
    machine: joeonebip program: dw.sapBIP_DVEBMGS00@joeonebip (TNS V1-V3)
    application name: SAPLRSBATCH, hash value=2488168175
    action name: 8979, hash value=747998402
  current SQL:
  INSERT INTO "/BIC/FZ1SD_C04" VALUES(:A0 ,:A1 ,:A2 ,:A3 ,:A4 ,:A5 ,:A6 ,:A7 ,:A8 ,:A9 ,:A10 ,:A11 ,:A12 ,:A13 ,:A14 ,:A15 ,:A16 ,:A17 ,:A18 ,:A19 ,:A20 ,:A21 ,:A22 )
 
----- End of information for the OTHER waiting sessions -----
 
Information for THIS session:
 
----- Current SQL Statement for this session (sql_id=2uk099pfqjyqm) -----
INSERT INTO "/BIC/FZ1SD_C04" VALUES(:A0 ,:A1 ,:A2 ,:A3 ,:A4 ,:A5 ,:A6 ,:A7 ,:A8 ,:A9 ,:A10 ,:A11 ,:A12 ,:A13 ,:A14 ,:A15 ,:A16 ,:A17 ,:A18 ,:A19 ,:A20 ,:A21 ,:A22 )
 
 
原因分析:一般数据库出现死锁的原因都是更新的时候互相锁定导致的,很少发现insert的时候出现的错误,如果是insert的时候报的错误,那么可能的原因就是往唯一键值插入一样的值;

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/12679300/viewspace-764995/,如需转载,请注明出处,否则将追究法律责任。

下一篇: what is an sap system
请登录后发表评论 登录
全部评论

注册时间:2013-06-16

  • 博文量
    173
  • 访问量
    2885540