oracle插入数据死锁,insert语句导致死锁，请大神指点原因

昨天数据库发现死锁，根据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)

2018-7-27 11:20 上传

点击文件名下载附件

5.96 MB, 下载次数: 11