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 will configure procedure cache ELC size as given 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)
   
Configuration option changed. Since the option is static, 
Adaptive Server must be rebooted in order for the change to take
effect.   
Changing the value of 'engine local cache percent' does not 
increase the amount of memory Adaptive Server