ORA-00060: deadlock detected while waiting for resource

How to get rid of ORA-60 deadlock error?

Cause: Transactions deadlocked one another while waiting for resources.

Action: Look at the trace file to see the transactions and resources involved. Retry if necessary.

Generally use “select for update” in your DML operation within loop will resolve this issue. But there are lots of other reasons for this kind of error. Your affected DML transactions will be failed due to this error.

If you are running DML transactions or batch job during busy hours of database then you should need to avoid such condition and schedule those batch job on off pick hours.

Due to poor application design this kind of deadlock or ORA-60 error occurs.

Missing indexes can also cause of this error.

There are lots of other reasons for this deadlock error. For more investigation you should need to open ticket to our remote DBA team and provide them all detail when you got this error. They will investigate issue and root cause of this error.

---