Wednesday, February 9, 2011

Oracle : Types of Locks

The locks are classified in many ways. The most common classifications are as below:-
Classification based on functionality
  1. DML locks (data locks)
  2. DDL locks (dictionary locks) 
  3. Oracle Internal Locks/Latches
  4. Oracle Distributed Locks
  5. Oracle Parallel Cache Management Locks
...to be continued