Symptom
In a heavy load system. Query monCacheProceduers, may find many cached queryplan for the same procedure.
For example:
PlanID MemUsageKB CompileDate ExecutionCount SP RequestCnt Active LogicalReads PhysicalWrites
----------- ----------- ------------------------------- -------------- -------------------------------------------------------------------------------- ----------- ------ ------------ --------------
63 660 Dec 8 2019 10:04PM 38 sp_helpserver 38 No 135249 696
65 752 Dec 8 2019 10:04PM 38 sp_autoformat 38 No 4740 199
67 660 Dec 8 2019 10:04PM 21 sp_helpserver 21 No 74693 349
69 752 Dec 8 2019 10:04PM 21 sp_autoformat 21 No 2648 125
Read more...
Environment
- SAP Adaptive Server Enterprise (ASE)
Keywords
CR820675, CR#820675, 820675, procedure cache full, duplicate cached procedure plan , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem
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