ORA-00060

What is a Deadlock?A deadlock occurs when a session (A) wants a resource held by another session (B) , but that session also wants a resource held by the first session (A). There can be more than 2 sessions involved but the idea is the same. The following example demonstrates a deadlock scenario. — Create Continue reading

The ORA-00060 error. As a DBA we can see that error message during daily database works. As you know that error referred to as a “deadlock detected” error. It occurs in Oracle databases when two or more sessions are unable to obtain the necessary locks on a set of rows because each session is waiting Continue reading