Hello,
We are getting ORA-0060 deadlock detected while waitinig for resoruce failure. Usually, DELETE/INSTERT/UPDATE statements cause this error, but this time SELECT(without UPDATE statement) is causing deadlock failure. Every time I try to drop replication between two databases, deadlock failure is occuring and waiting session which includes the SELECT statement is remaining the same. We are not able to reproduce it on our labs, it is reproducible only a customer site.
Do you have any idea how SELECT statement causes the deadlock failure? or any idea how can we solve this problem.
Oracle Version: 11.2.0.3.11
Thanks