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.