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.