Locks & Deadlocks
Published July 26, 2025
By Sai Sree Ram Gundepudi
Locks and Deadlocks
Oracle uses locks to maintain data integrity in concurrent access.
Types of Locks:
- Row-level Locks
- Table-level Locks
Deadlock Example:
Occurs when two sessions block each other by locking resources the other needs. Oracle detects and resolves deadlocks automatically by rolling back one session.