SAP Knowledge Base Article - Preview

3231350 - Queries are not using Statement Cache - SAP ASE

Symptom

  • sp_w or sp_who output commands are reporting sessions with "COMPILING" as command (cmd) during long time.
  • Queries executed on ASE 16.0 SP03 PL12 & PL13 or SP04 PL02 to PL04 are not getting put into the statement cache. As result, it is observed several queries optimization/compilation done.


Read more...

Environment

SAP Adaptive Server Enterprise (ASE) 16.0 SP03 from PL12 to PL13, and ASE 16.0 SP04 from PL02 to SP04 PL04.

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 15.7 Cluster Edition ; SAP Adaptive Server Enterprise 16.0 ; SAP Adaptive Server Enterprise 16.0 Cluster Edition

Keywords

TF7790, 7790, CR 827881, 827881, CR827881, "max cached stmt size", CR 826002, 826002, CR826002 , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , BC-SYB-ASE-CE , ASE Cluster Edition (Standalone) , BW-SYS-DB-SYB , BW on Adaptive Server Enterprise , 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.