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.