Data and Procedure Caches
Specify the size of the data and procedure caches.
Determining the Procedure Cache Size
Use procedure cache size to specify, or view, the size of your procedure cache in 2K pages, regardless of the server’s logical page size.
Determining the Default Data Cache Size
Both sp_cacheconfig and sp_helpcache display the current default data cache in megabytes.
Monitoring Cache Space
Check data cache and procedure cache space with the total data cache size configuration parameter.
Modify the ELC Size
The configuration option engine local cache percent configures Engine Local Cache (ELC) size for procedure cache memory.
Parent topic:
Configuration Parameters That Control SAP ASE Memory
Created May 28, 2014. Send feedback on this help topic to Technical Publications:
pubs@sap.com