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