SAP Knowledge Base Article - Preview

3326910 - Feature request to have des_greedyalloc persists between ASE reboots - SAP ASE

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.