1.

What Is The Difference Between Latches And Enqueues?

Answer»
  • Enqueue is used to queue request for lock on any DB object that can't be served immediately and session is ready to wait.
  • Latches are internal locking mechanism of Oracle to provide short term exclusive access to Oracle's internal objects LIKE LIBRARY cache etc.
  • Another DIFFERENCE is that ENQUEUES follow first in first out (FIFO) algorithm while latches do not follow any such algorithm.



Discussion

No Comment Found