解决ORA-00060: Deadlock detected小例
数据库版本：
SQL > select * from v$version; BANNER ---------------------------------------------------------------- Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bi PL/SQL Release 10.2.0.5.0 - Production CORE 10.2.0.5.0 Production TNS for Linux: Version 10.2.0.5.0 - Production NLSRTL Version 10.2.0.5.0 - Production
事件：数据库产生死锁：
ORA-00060: Deadlock detected
alert 日志如下：
ORA-00060: Deadlock detected. More info in file /u01/app/oracle/admin/xezf/udump/xezf_ora_13794.trc. Wed Jul 10 12:39:00 CST 2013 ORA-00060: Deadlock detected. More info in file /u01/app/oracle/admin/xezf/udump/xezf_ora_13792.trc. Wed Jul 10 12:40:02 CST 2013 ORA-00060: Deadlock detected. More info in file /u01/app/oracle/admin/xezf/udump/xezf_ora_13794.trc. Wed Jul 10 12:41:56 CST 2013 ORA-00060: Deadlock detected. More info in file /u01/app/oracle/admin/xezf/udump/xezf_ora_13790.trc. Wed Jul 10 12:43:00 CST 2013 ORA-00060: Deadlock detected. More info in file /u01/app/oracle/admin/xezf/udump/xezf_ora_13792.trc. Wed Jul 10 12:44:54 CST 2013 ORA-00060: Deadlock detected. More info in file /u01/app/oracle/admin/xezf/udump/xezf_ora_13792.trc. Wed Jul 10 12:48:09 CST 2013 ORA-00060: Deadlock detected. More info in file /u01/app/oracle/admin/xezf/udump/xezf_ora_13794.trc. Wed Jul 10 12:57:01 CST 2013 Thread 1 advanced to log sequence 33866 (LGWR switch) Current log# 3 seq# 33866 mem# 0: /u02/oradata/xezf/redo30.log Current log# 3 seq# 33866 mem# 1: /u01/app/oracle/oradata/redo32.log Wed Jul 10 12:57:03 CST 2013 ARC0: Standby redo logfile selected for thread 1 sequence 33865 for destination LOG_ARCHIVE_DEST_2 Wed Jul 10 12:57:09 CST 2013 ORA-00060: Deadlock detected. More info in file /u01/app/oracle/admin/xezf/udump/xezf_ora_13782.trc. Wed Jul 10 13:03:59 CST 2013 ORA-00060: Deadlock detected. More info in file /u01/app/oracle/admin/xezf/udump/xezf_ora_13794.trc. Wed Jul 10 13:08:55 CST 2013 ORA-00060: Deadlock detected. More info in file /u01/app/oracle/admin/xezf/udump/xezf_ora_13780.trc. Wed Jul 10 13:12:58 CST 2013 ORA-00060: Deadlock detected. More info in file /u01/app/oracle/admin/xezf/udump/xezf_ora_13780.trc. Wed Jul 10 13:16:06 CST 2013 ORA-00060: Deadlock detected. More info in file /u01/app/oracle/admin/xezf/udump/xezf_ora_13782.trc. Wed Jul 10 13:18:07 CST 2013 Thread 1 advanced to log sequence 33867 (LGWR switch) Current log# 10 seq# 33867 mem# 0: /u02/oradata/xezf/redo10a.log Current log# 10 seq# 33867 mem# 1: /u01/app/oracle/oradata/redo10b.log Wed Jul 10 13:18:10 CST 2013 ARC0: Standby redo logfile selected for thread 1 sequence 33866 for destination LOG_ARCHIVE_DEST_2 Wed Jul 10 13:24:07 CST 2013 ORA-00060: Deadlock detected. More info in file /u01/app/oracle/admin/xezf/udump/xezf_ora_13794.trc. Wed Jul 10 13:36:59 CST 2013 ORA-00060: Deadlock detected. More info in file /u01/app/oracle/admin/xezf/udump/xezf_ora_13794.trc. Wed Jul 10 13:38:03 CST 2013 ORA-00060: Deadlock detected. More info in file /u01/app/oracle/admin/xezf/udump/xezf_ora_13794.trc. Wed Jul 10 13:40:58 CST 2013 ORA-00060: Deadlock detected. More info in file /u01/app/oracle/admin/xezf/udump/xezf_ora_13780.trc. Wed Jul 10 13:42:08 CST 2013 Thread 1 advanced to log sequence 33868 (LGWR switch) Cur