engine local cache percent enables or disables modification of the Engine Local Cache (ELC) as a percentage of procedure cache.
|
Summary Information |
|
|---|---|
|
Default value |
50 |
|
Range of values |
0–100 |
|
Status |
Static |
|
Display level |
Comprehensive |
|
Required role |
System administrator |
|
Configuration group |
Meta-Data Caches |
Based on this configuration option, SAP ASE will configure procedure cache ELC size as given percentage of procedure cache size. The default value is 50, which means the ELC size will be 50% of procedure cache size.
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.
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