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

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

5,683

111

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/14oBm...