Oracle Locks Simplified [Part-I] - Understanding Locks Deadlocks and Blocking Locks

In this first part of the tutorial, we are going to learn about oracle locks, deadlocks and blocking locks. A lock in oracle is a mechanism by which oracle maintains the data consistency. Oracle locks are expected behavior, whereas deadlocks (ORA-60) are something that Oracle resolves automatically but blocking locks are something that make the situation worse and has severe performance implications. In this video I am demonstrating each of these scenarios to understand them better. In the second part of the tutorial, we will learn about how to detect and alert on a blocking lock situation using an OEM Metric Extension. For the SQLs used in this tutorial, please refer to my google doc that is shared through the link below: https://drive.google.com/file/d/14oBmuubJA9X1Iq2hXggyBNnngjRfa3up/view?usp=sharing