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:
[ Ссылка ]
