ORA-00060 Deadlock: How to Find, Fix, and Prevent It

ORA-00060 deadlocks in Oracle are often misunderstood: they roll back one statement, not the entire transaction, and are usually application bugs, not database tuning issues. Oracle automatically detects and breaks deadlocks within seconds, leaving a trace file with a deadlock graph. Developers must handle the error in PL/SQL by retrying the failed statement after a short backoff.