Tag Archives: autonomous_transaction

单一会话引发的死锁

客户环境中出现了ORA-60死锁错误,检查日志发现,持有锁和等待锁的是同一个会话。 一般来说构成死锁至少需要两个会话,而当前的问题是一个会话引发的: Wed Nov 23 10:19:46 2011 ORA-00060: Deadlock detected. More info IN file /oracle/admin/db1/udump/db1_ora_3408686.trc. 对应的详细信息: *** 2011-10-29 10:11:28.970 *** SERVICE NAME:(db1) 2011-10-29 10:11:28.960 *** SESSION ID:(5562.45) 2011-10-29 10:11:28.960 DEADLOCK DETECTED ( ORA-00060 ) [TRANSACTION Deadlock] The following deadlock IS … Continue reading

Posted in ORACLE | Tagged , | Leave a comment