SAP Knowledge Base Article - Preview

2548423 - Only NumSearches of monStatementCache increases when a dynamic SQL runs multiple times - SAP ASE

Symptom

Only NumSearches of monStatementCache increases when a dynamic SQL statement runs multiple times in the following order.

  1. Set transaction isolation level
  2. Prepare a statement
  3. Change transaction isolation level
  4. Execute the prepared statement with parameters.


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.7
  • SAP Adaptive Server Enterprise (ASE) 16.0

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

NumSearches, HitCount, NumInserts, monStatementCache, statement cache, streamlined dynamic SQL, prepared statement, PreparedStatement, DYNAMIC_PREPARE, SQLPrepare , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , 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.