資料庫ORA-0060錯誤

發現資料庫報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:
  client details:
    O/S info: user: bipadm, term: , ospid: 9306112
    machine: joeonebip program: (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的時候報的錯誤，那麼可能的原因就是往唯一鍵值插入一樣的值；