Symptom
- sp_configure shows incorrect 'Memory Used' values with a '#' sign or as '#1' for large configuration values of memory related parameters.
- For example:
1> sp_configure 'max memory', 0, '2048G'
2> go
Parameter Name Default Memory Used Config Value Run Value Unit Type
-------------------------------- ---------------------- -------------------------- ---------------------------- ------------------------ -------------------------------- --------------
max memory 180224 #2147483648 1073741824 1073741824 memory pages(2k) dynamic
1> sp_configure 'procedure cache',0,'3600G'
2> go
Parameter Name Default Memory Used Config Value Run Value Unit Type
-------------------------------- ---------------------- -------------------------- ---------------------------- ------------------------ -------------------------------- --------------
procedure cache size 14000 #1 1887436800 1887436800 memory pages(2k) dynamic
Read more...
Environment
SAP Adaptive Server Enterprise (ASE) 16.0
Product
SAP Adaptive Server Enterprise 16.0
Keywords
CR813224, CR#813224, 813224, syscurconfigs, memory_used, overflow , 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