Step-By-Step Detect Oracle Database Locks Using SQL

Опубликовано: 28 Сентябрь 2024
на канале: YouVolve

1,711

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 SQL statements

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