The Cache Buffer Chains Latch Wait alarm occurs when contention for the cache buffer chains latch exceeds a threshold.
Two main latches protect data blocks in the buffer cache.
Contention for these latches usually occurs in a database that has very high I/O rates. It may be possible to reduce contention for the cache buffer LRU chain latch by increasing the size of the buffer cache. Doing this reduces the rate at which new blocks are introduced into the buffer cache.
Reducing contention for the cache buffer chains latch usually requires reducing logical I/O rates by tuning and minimizing the I/O requirements of application SQL.
You can create additional cache buffer LRU chain latches by adjusting the hidden configuration parameter _DB_BLOCK_LRU_LATCHES.
You may be able to reduce the load on the cache buffer chain latches by increasing the value of the hidden configuration parameter _DB_BLOCK_HASH_BUCKETS.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. 이용 약관 개인정보 보호정책 Cookie Preference Center