Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

difference between cache buffer chain latch and buffer busy wait

952873Jul 30 2012 — edited Jul 30 2012
Hi

Does cache buffer chain latch and buffer busy wait event are related to one any another.


Latch definition from google says : Latches are simple, low-level serialization mechanisms to protect shared data structures in the system global area (SGA).

what does it mean my protect. Does this mean protects from aging as per LRU algorithm and getting removed from SGA
or
protect from other processes ,say from example from simultaneously DML operations.
or
both

Does buffer busy wait event occurs , because of the cache buffer chain latch ?

Thanks
Naveen.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 27 2012
Added on Jul 30 2012
3 comments
1,325 views