一次Oracle频繁DeadLock问题分析处理经历

事件描述

早上十点，客户电话打来，描述了一下业务缓慢，卡的已经不能正常进行下去，几句询问赶紧着手处理。


接过远程后，赶紧连上数据库服务器查看资源状态，发现整体状态趋于正常，询问客户，得知目前业务
已恢复正常，就是刚刚卡的进行不下去。这是怎么回事呢？

好吧，首先翻看告警日志，发现早上九点到十点钟死锁报错间断进行。

Sat Nov 16 09:07:21 2019
ORA-00060: Deadlock detected. More info in file e:\app\dnsapp\diag\rdbms\xxxxxxdb\xxxxxxdb\trace\xxxxxxdb_ora_4296.trc.
Sat Nov 16 09:07:21 2019
ORA-00060: Deadlock detected. More info in file e:\app\dnsapp\diag\rdbms\xxxxxxdb\xxxxxxdb\trace\xxxxxxdb_ora_6312.trc.
Sat Nov 16 09:07:24 2019
ORA-00060: Deadlock detected. More info in file e:\app\dnsapp\diag\rdbms\xxxxxxdb\xxxxxxdb\trace\xxxxxxdb_ora_6876.trc.
Sat Nov 16 09:10:17 2019
ORA-00060: Deadlock detected. More info in file e:\app\dnsapp\diag\rdbms\xxxxxxdb\xxxxxxdb\trace\xxxxxxdb_ora_4296.trc.
Sat Nov 16 09:20:07 2019
ORA-00060: Deadlock detected. More info in file e:\app\dnsapp\diag\rdbms\xxxxxxdb\xxxxxxdb\trace\xxxxxxdb_ora_6292.trc.
Sat Nov 16 09:20:07 2019
ORA-00060: Deadlock detected. More info in file e:\app\dnsapp\diag\rdbms\xxxxxxdb\xxxxxxdb\trace\xxx