Step-By-Step - Detect and Resolve Blocking Locks in Oracle Database Using OEM

Опубликовано: 06 Октябрь 2024
на канале: YouVolve
4,434
59

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...