Symptom
- sp_monitorconfig "heap memory per user" is reporting Pct_act at 100%:
Name Num_free Num_active Pct_act Max_Used Reuse_cnt Instance_Name
------------------------- ----------- ----------- ------- ----------- ----------- ------------------------------
heap memory per user 0 25895 100.00 25895 0 NULL
- The Num_active and Max_Used counters may exceeed the configured value for the "heap memory per user" parameter:
sp_configure:
Parameter Name Default Memory Used Config Value Run Value Unit Type
------------------------------ ----------- ----------- ------------ ------------ -------------------- --------------------
heap memory per user 4096 109981696 6144 6144 bytes dynamic
sp_monitorconfig:
Name Num_free Num_active Pct_act Max_Used Reuse_cnt Instance_Name
------------------------- ----------- ----------- ------- ----------- ----------- ------------------------------
heap memory per user 0 8360 100.00 8360 0 NULL
- The Reuse_cnt counter remains set to 0 (zero).
Read more...
Environment
SAP Adaptive Server Enterprise (ASE)
Product
Keywords
CR400980, CR#400980, 400980, config_admin, global, pool , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed
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.
SAP Knowledge Base Article - Preview