Re: Block level contention

Posted by satish on
URL: http://erman-arslan-s-oracle-forum.114.s1.nabble.com/Block-level-contention-tp7249p7251.html

Thanks for the update erman

Can both the users read the block header at the same time?

Oracle says "Cache buffers chains latches are taken when a process wants to walk through a cache buffer hash chain, looking if the block with required DBA (data block address) is in buffer cache. If the block happens to be in cache, then in most cases it has to be pinned first before use and unpinned after use, to make sure no-one else can perform an incompatible operation on that block at the same time. The modification of pin structures (pinning/unpinning) is also protected by CBC latches."

So,if multiple selects or multiple updates occurs on same block,then each one has to wait to get the latch?


Thanks for all the support.