Symptom
- With large number of processors, latch contention on allocation page becomes an issue. "greedy allocation" scheme provides a solution. This feature is available since ASE 12.0.
- "greedy allocation" scheme keeps a list of 16 allocation hints for page allocation instead of 1 hint per object.
- Use dbcc tune command to enable/disable the "greedy allocation" for an object. This dbcc command is not persistent during reboot. Once the ASE is reboot, this command needs to run again to enable the "greedy allocation".
Read more...
Environment
SAP Adaptive Server Enterprise
Product
SAP Adaptive Server Enterprise 16.0
Keywords
dbcc tune,des_greedyalloc,OAM scans,insert,latch sleep,blocking , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Product Enhancement
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.