insert语句导致死锁，请大神指点原因

ray_suen 2018-07-30 03:25:05

数据库发现死锁，根据trace文件内提示的object id查询为表的主键索引，下面是部分trace文件的内容。请大神指定原因：

[Transaction Deadlock]

The following deadlock is not an ORACLE error. It is a
deadlock due to user error in the design of an application
or from issuing incorrect ad-hoc SQL. The following
information may aid in determining the deadlock:

Deadlock graph:
---------Blocker(s)-------- ---------Waiter(s)---------
Resource Name process session holds waits process session holds waits
TX-00080004-0000356d 30 1993 X 63 2135 S
TX-0002001d-000032ad 63 2135 X 67 432 S
TX-0004000f-00002680 67 432 X 58 1424 S
TX-00170019-00002985 58 1424 X 30 1993 S

session 1993: DID 0001-001E-0000001B session 2135: DID 0001-003F-00000005
session 2135: DID 0001-003F-00000005 session 432: DID 0001-0043-00000005
session 432: DID 0001-0043-00000005 session 1424: DID 0001-003A-00000006
session 1424: DID 0001-003A-00000006 session 1993: DID 0001-001E-0000001B

Rows waited on:
Session 1993: no row
Session 2135: obj - rowid = 0000403D - AAAEA9AAfAAAAJIAAA
(dictionary objn - 16445, file - 31, block - 584, slot - 0)
Session 432: no row
Session 1424: obj - rowid = 0000403D - AAAEA9AAdAAHErcAAA
(dictionary objn - 16445, file - 29, block - 1854172, slot - 0)

----- Information for the OTHER waiting sessions -----
Session 2135:
sid: 2135 ser: 37 audsid: 16230041 user: 46/CUT
flags: (0x45) USR/- flags_idl: (0x1) BSY/-/-/-/-/-
flags2: (0x40009) -/-/INC
pid: 63 O/S info: user: grid, term: UNKNOWN, ospid: 128279
image: oracle@dbs0xjlcprc01
client details:
O/S info: user: devuser, term: , ospid: 11536
machine: mds0xjlcprc01 program: odbcserver@mds0xjlcprc01 (TNS V1-V3)
application name: odbcserver@mds0xjlcprc01 (TNS V1-V3), hash value=4150815403
current SQL:
insert into cut.mlc_dataserver_ddt(SETTLEMENT_DATE, BATCH_ID, MESSAGE_ID, TIME_STAMP) values (to_date('20180724','yyyymmdd'), '015D89230120180723071629BF63', '03201807241735578B2D5D8923016201', sysdate)

Session 432:
sid: 432 ser: 11 audsid: 16230045 user: 46/CUT
flags: (0x45) USR/- flags_idl: (0x1) BSY/-/-/-/-/-
flags2: (0x40009) -/-/INC
pid: 67 O/S info: user: grid, term: UNKNOWN, ospid: 128289
image: oracle@dbs0xjlcprc01
client details:
O/S info: user: devuser, term: , ospid: 11524
machine: mds0xjlcprc01 program: odbcserver@mds0xjlcprc01 (TNS V1-V3)
application name: odbcserver@mds0xjlcprc01 (TNS V1-V3), hash value=4150815403
current SQL:
insert into cut.mlc_dataserver_ddt(SETTLEMENT_DATE, BATCH_ID, MESSAGE_ID, TIME_STAMP) values (to_date('20180724','yyyymmdd'), '015D89230120180723080129CB64', '0320180724173557932D5D8923016201', sysdate)

Session 1424:
sid: 1424 ser: 53 audsid: 16230036 user: 46/CUT
flags: (0x45) USR/- flags_idl: (0x1) BSY/-/-/-/-/-
flags2: (0x40009) -/-/INC
pid: 58 O/S info: user: grid, term: UNKNOWN, ospid: 128271
image: oracle@dbs0xjlcprc01
client details:
O/S info: user: devuser, term: , ospid: 11510
machine: mds0xjlcprc01 program: odbcserver@mds0xjlcprc01 (TNS V1-V3)
application name: odbcserver@mds0xjlcprc01 (TNS V1-V3), hash value=4150815403
current SQL:
insert into cut.mlc_dataserver_ddt(SETTLEMENT_DATE, BATCH_ID, MESSAGE_ID, TIME_STAMP) values (to_date('20180724','yyyymmdd'), '015D89230120180723080129C264', '0320180724173557922D5D8923016201', sysdate)

...全文