SAP Knowledge Base Article - Preview

2284407 - Usage count of statements in statement cache is too high - SAP ASE

Symptom

  • Number of statements in the statement cache have a very high number for Current Usage.
  • The usage count is higher than the number of connections.
  • Outputs that show the issue are query on monCachedStatement or dbcc prsqlcache :
     
        select CurrentUsageCount , MaxUsageCount from monCachedStatement where SSQLID = <ID of problem statement>
    or
        dbcc prsqlcache(<SSQLID of problem statement>, 1)             => the ssql_usecnt field


Read more...

Environment

SAP Adaptive Server Enterprise (ASE) 15.7

Product

SAP Adaptive Server Enterprise 15.7

Keywords

CR805162, CR#805162, 805162, procedure, purge, delete , 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.