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.

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)