This is a part of the topic on understanding and handling the most common oracle locks in a simplified way. In the first part of this topic we learned about locks, deadlocks and blocking locks using a few test cases and some real-life examples. if you have not watched the first part, I suggest you watch that first to get a better understanding of the topic on today's video.
Link to Part-I: • Oracle Locks Simplified [Part-I] - Un...
In this part, we are going to a little deeper into the blocking lock issue and learn:
How to detect a blocking lock using OEM.
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/14oBm...