数据库ORA-0060错误

最新推荐文章于 2023-03-19 17:22:04 发布

cltt980248285

最新推荐文章于 2023-03-19 17:22:04 发布

阅读量749

点赞数

文章标签：数据库

发现数据库报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/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/12679300/viewspace-764995/