Deadlock details : ORA-00060
Hello All,
This request is for understanding deadlock concept. Have gone through few documents but still looking for some additional information. All your suggestion helps in tuning one of our critical box.
Generic definition for deadlocks is -
Deadlock (ORA-00060) is caused by competing resources, the perpetual embrace happens when the aborted task (Task attempts to lock a row which is being held by another task (Task A), which, in-turn, is waiting for task B to release a lock. To prevent a perpetual wait, Oracle aborts the transaction that caused the deadlock.
So are these kind of locks expected for all DML statements or is it only when there is INSERT/UPDATE statements fired.
This request is for understanding deadlock concept. Have gone through few documents but still looking for some additional information. All your suggestion helps in tuning one of our critical box.
Generic definition for deadlocks is -
Deadlock (ORA-00060) is caused by competing resources, the perpetual embrace happens when the aborted task (Task attempts to lock a row which is being held by another task (Task A), which, in-turn, is waiting for task B to release a lock. To prevent a perpetual wait, Oracle aborts the transaction that caused the deadlock.
So are these kind of locks expected for all DML statements or is it only when there is INSERT/UPDATE statements fired.
0