标题: ORA-00060：Deadlock detected检测到死锁 [打印本页] 作者: Inkcup 时间: 2025-9-28 18:31 标题: ORA-00060：Deadlock detected检测到死锁 ORA-00060: Deadlock detected. See Note 60.1 at My Oracle Support for Troubleshooting ORA-60 Errors. More info in file /u01/app/oracle/diag/rdbms/lisdb/orcl/trace/orcl_ora_2021204.trc.
摘自对应的追踪文件：
[Transaction Deadlock]
The following deadlock is not an ORACLE error. It is a
deadlock due to user error in the design of an application
or from issuing incorrect ad-hoc SQL. The following
information may aid in determining the deadlock:
Deadlock graph:
------------Blocker(s)----------- ------------Waiter(s)------------
Resource Name process session holds waits serial process session holds waits serial
TX-00120005-00071298-00000000-00000000 202 4830 X 28154 263 3426 X 32836
TX-0010001B-001427BC-00000000-00000000 263 3426 X 32836 202 4830 X 28154
-----
这是一个Oracle数据库死锁错误。死锁发生在两个或多个会话相互等待对方持有的资源时，数据库会自动检测到并回滚其中一个事务。