SAP Knowledge Base Article - Preview

3707695 - Query using except causes consuming procedure cache - ASE

Symptom

  • A query using except clause is consuming large amount of procedure cache
  • The table being queried is a very large table with millions of rows
  • Attempting to kill process consuming procedure cache does not kill immediately
  • A 701 is not  immediately reported
  • If a 701 is later reported, the process consuming memory may resolve it self


Read more...

Environment

Adaptive Server Enterprise (ASE) 16.0 SP04

Product

SAP Adaptive Server Enterprise 16.0.4

Keywords

except, intersect, CR 831709, 831709, high, cpu , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Product Enhancement

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.