Home
About Us
Contact Us
Bookmark
Saved Bookmarks
Current Affairs
General Knowledge
Chemical Engineering
UPSEE
BSNL
ISRO
BITSAT
Amazon
ORACLE
Verbal Ability
→
Oracle Dba Troubleshooting Tutorial
→
Oracle Dba Troubleshooting Interview Questions in Oracle Dba Troubleshooting Tutorial
→
What Is The Difference Between Latches And Enqueu...
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.
Show Answer
Discussion
No Comment Found
Post Comment
Related InterviewSolutions
How Can You Detect Block Corruption?
How Do You Handle Ora-01403: No Data Found Error?
What Are The Different Types Of Locking Modes?
Name A Few Places You Will Look To Get More Details On A Performance Issue?
Describe The Oracle Wait Interface?
How Can You Monitor Performance Of The Database Proactively?
Which Trace File Is Used For Performance Tuning And Why?
What Do The Db_file_sequential_read And Db_file_scattered_read Events Indicate?
What Do You Understand By Db File Scattered Read?
What Is The Main Reason For Block Corruption?
Reply to Comment
×
Name
*
Email
*
Comment
*
Submit Reply
Your experience on this site will be improved by allowing cookies. Read
Cookie Policy
Reject
Allow cookies