Tuesday, August 7, 2012

Differences between locks and latches in Oracle

  • Latches provide only exclusive access to protected data structures
  • Locks allow serialized access to some resources
  • Latches protect resources that are briefly needed (LRU list)
  • Locks protect resources needed for a long time (tables)

No comments:

Post a Comment