数据库ORA-0060错误

简介: 发现数据库报ORA-0060的错误,详细如下: Deadlock graph:                       ---------Blocker(s)--------  ---------Waiter(s)---------Re...
发现数据库报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的时候报的错误,那么可能的原因就是往唯一键值插入一样的值;
相关文章
|
SQL 监控 Oracle
Oracle 数据库报错:ORA-12592问题排查过程
Oracle 数据库报错:ORA-12592问题排查过程
3455 0
|
11月前
|
数据库
数据库启动报ORA-03113错误
数据库启动的时候出错
|
SQL Oracle 关系型数据库
|
数据库 关系型数据库 Oracle

热门文章

最新文章