Opening book details…
Can I read Understanding Oracle Deadlocks on EtoBox?
Understanding Oracle Deadlocks by karthikmas is a document available to read on EtoBox.
What is Understanding Oracle Deadlocks about?
A deadlock occurs when two processes concurrently try to access the same resources in incompatible ways, such as when one process has a lock on resource A while waiting for a lock on resource B, and another process has a lock on resource B while waiting for a lock on resource A. The document demonstrates a deadlock occurring between two sessions trying to update the same rows in a table. When Oracle detects a deadlock, it rolls back one of the statements and returns an error.
- Author
- karthikmas
- Language
- EN