Salesforce

Corrupted data in PROMON "Status: Buffer Cache" causes performance degradation

« Go Back

Information

 
TitleCorrupted data in PROMON "Status: Buffer Cache" causes performance degradation
URL Namecorrupted-data-in-status-buffer-cache-and-performance-degradation
Article Number000112077
EnvironmentProduct: OpenEdge
Version: 10.2B, 11, 12
OS: All Supported Platforms
Question/Problem Description
Performance degradation due to corrupted data in "Promon:Status: Buffer Cache”.
“Used buffers” are larger than “Total buffers” in the "PROMON > R&D > Status Displays > Buffer Cache"
 
Steps to Reproduce
Clarifying Information
Error Message
Defect NumberOCTA-11729
Enhancement Number
Cause
The issue with the alternative buffer pool having more entries than assigned space is that, when an entry on LRU2 is dequeued from LRU2 and moved to APW quene for page writer to flush, during that time, another buffers can be added to LRU2. Later when the page writer flush the buffer and put it back on LRU2, the LRU chain might be already full.

This causes LRU2 entries exceeded the allocated numbers. Performance degrades when too many buffers on LRU are moved to LRU2 chain and causes a low buffer hit ratio on the general buffer pool low. The issue found only with object-level B2. 
Resolution
Fixed version(s): 11.7.6.0, OpenEdge 12.2
Workaround
Restart the database and resize the Alternate Buffer Pool to include 1 cluster of blocks for each object assigned to it in addition to the considered size of the objects blocks.
 
Notes
Keyword Phrase
Last Modified Date10/25/2023 1:25 PM

Powered by