Modify the ELC Size

The configuration option engine local cache percent configures Engine Local Cache (ELC) size for procedure cache memory.

Based on this configuration option, SAP ASE configures procedure cache ELC size as a percentage of procedure cache size.

Default value for this configuration is 50. Which means ELC size will be 50% of procedure cache size.
It is a static option; SAP ASE needs to be rebooted for the option to take effect.
This configurations option can be used only when large ELC is enabled (using boot time traceflag 758).
For optimal performance, a value no larger than 80 is recommended.

Example:

1> sp_configure "engine local cache percent",70   
2> go   
Parameter Name Default Memory Used Config Value Run Value Unit Type
-------------- ------- ----------- ------------ --------- ---- ----  
    engine   local cache percent  50   0   70  50  percent static   
(1 row affected)