环境:
Oracle12C Rac
业务系统近期出现2次死锁,日志如下:
2021-12-27T15:28:28.665240+08:00
Global Enqueue Services Deadlock detected (DID = 28_1_1). More information in file
/u01/app/oracle/diag/rdbms/orcl/orcl2/trace/orcl2_lmd0_10328.trc.
2021-12-27T15:29:28.788629+08:00
Global Enqueue Services Deadlock detected (DID = 28_1_2). More information in file
/u01/app/oracle/diag/rdbms/orcl/orcl2/trace/orcl2_lmd0_10328.trc.
2021-12-27T15:29:58.931100+08:00
Global Enqueue Services Deadlock detected (DID = 28_1_3). More information in file
/u01/app/oracle/diag/rdbms/orcl/orcl2/trace/orcl2_lmd0_10328.trc.
2021-12-27T15:30:58.908192+08:00
Global Enqueue Services Deadlock detected (DID = 28_1_4). More information in file
/u01/app/oracle/diag/rdbms/orcl/orcl2/trace/orcl2_lmd0_10328.trc.
2021-12-27T15:41:48.910468+08:00
Global Enqueue Services Deadlock detected (DID = 28_1_5). More information in file
/u01/app/oracle/diag/rdbms/orcl/orcl2/trace/orcl2_lmd0_10328.trc.
2021-12-27T15:53:12.776506+08:00
Global Enqueue Services Deadlock detected (DID = 28_1_6). More information in file
/u01/app/oracle/diag/rdbms/orcl/orcl2/trace/orcl2_lmd0_10328.trc.
2021-12-27T15:54:22.873278+08:00
Global Enqueue Services Deadlock detected (DID = 28_1_7). More information in file
/u01/app/oracle/diag/rdbms/orcl/orcl2/trace/orcl2_lmd0_10328.trc.
2021-12-27T16:46:48.908953+08:00
Global Enqueue Services Deadlock detected (DID = 28_1_8). More information in file
/u01/app/oracle/diag/rdbms/orcl/orcl2/trace/orcl2_lmd0_10328.trc