SAP Knowledge Base Article - Preview

2748384 - sp_configure: Incorrect Memory Used values with a '#' sign or as '#1' for large configuration settings - SAP ASE 16.0

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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.