今天在drop一个用户的时候hang住了,开始没有在意,结果过了1个小时还没有删除完,这个用户中的对象并不是很多而且也不大,于是去看了下alert日志,结果发现如下的信息:
ORA-00060: Deadlock detected. More info in file /u01/app/oracle/diag/rdbms/tlgdb/tlgdb/trace/tlgdb_ora_14577.trc.
ORA-00060: Deadlock detected. More info in file /u01/app/oracle/diag/rdbms/tlgdb/tlgdb/trace/tlgdb_ora_14577.trc.
ORA-00060: Deadlock detected. More info in file /u01/app/oracle/diag/rdbms/tlgdb/tlgdb/trace/tlgdb_ora_14577.trc.
ORA-00060: Deadlock detected. More info in file /u01/app/oracle/diag/rdbms/tlgdb/tlgdb/trace/tlgdb_ora_14577.trc.
这样信息不断的出现,“死锁”,trc中的信息特别的多如下是其中的一部分:
[10:37:46]DEADLOCK DETECTED ( ORA-00060 )
[10:37:46]
[10:37:46][Transaction Deadlock]
[10:37:46]
[10:37:46]The following deadlock is not an ORACLE error. It is a
[10:37:46]deadlock due to user error in the design of an application
[10:37:46]or from issuing incorrect ad