Manage Deadlocks in Oracle | Oracle 12c Administration

Oracle Database is designed to avoid #deadlocks, and they are not common. Most often they occur when #transactions explicitly override the default locking of the #database. Deadlocks can affect the performance of your database, so #Oracle provides some scripts and views that enable you to monitor locks.
Oracle Database automatically detects deadlocks and resolves them by rolling back one statement involved in the deadlock, releasing one set of the conflicting row locks. The database returns a corresponding message to the transaction that undergoes statement-level #rollback.
The statement rolled back belongs to the transaction that detects the deadlock. Usually, the signaled transaction should be rolled back explicitly, but it can retry the rolled-back statement after waiting

00:00 Deadlock
10:39 Removing deadlocks in Oracle
11:20 Resolving deadlocks

Website: https://www.dbagenesis.com/
Facebook:   / dbagenesis  
Instagram:   / dbagenesis  
Twitter:   / dbagenesis