Oracle Database Locks and How to check locks | Oracle Deadlocks

What is a database lock in the context of #SQL? ... When #data is locked, then that means that another #database session can NOT update that data until the lock is released (which unlocks the data and allows other database users to update that data. Locks are usually released by either a #ROLLBACK or #COMMIT SQL statement.

00:00 Database ACID Properties
04:05 Locks
04:12 Scenario of starting locks examples-1
20:51 Scenario of starting locks Examples-2
29:58 Scenario of starting locks LAB
46:16 Row level locks and Table level locks
52:49 Identify Blockers and Waiters inside the database
54:18 Find Locked Table Inside Oracle
55:28 Find blocked session
01:00:11 Find Lock wait time
01:02:02 Find blocked SQL
01:03:32 Find locked table
01:12:14 Resolving locks in Oracle
01:17:39 Database blocked Session Report
01:18:32 Why locks are not bad inside the database?

Website: https://www.dbagenesis.com/
Facebook:   / dbagenesis  
Instagram:   / dbagenesis  
Twitter:   / dbagenesis