Symptom
- Num_active and Max_Used counters for the "procedure cache size" in the sp_monitorconfig output exceed configuration value:
- <sp_configure "procedure cache size">
Parameter Name Default Memory Used Config Value Run Value Unit Type
-------------------- ----------- ------------- -------------- ------------ ---------------- -------
procedure cache size 14000 33525 14000 14000 memory pages(2k) dynamic - <sp_monitorconfig "procedure cache size">
Name Num_free Num_active Pct_act Max_Used Reuse_cnt Instance_Name
------------------------- ----------- ----------- ------- ----------- ----------- --------------
procedure cache size 0 17371 100.00 17371 0 NULL
- <sp_configure "procedure cache size">
- Pct_act counter shows 100%
- Reuse_cnt counter remains 0
Read more...
Environment
SAP Adaptive Server Enterprise (ASE)
Product
SAP Adaptive Server Enterprise 16.0
Keywords
KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , How To
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.