SAP Knowledge Base Article - Preview

2374915 - "Number of open objects" steadily growing or running out - SAP ASE

Symptom

  • “Increase the config parameter 'number of open objects' ” messages are reported in the ASE errorlog.
  • The number of 'Used' open objects is steadily growing per sp_monitorconfig reports.
  • Running command sp_countmetadata 'open objects' returns a (much) smaller number than number of objects in use:

There are 8376 user objects in all database(s), requiring 148314 Kbytes of memory. The 'open objects' configuration parameter is currently set to 50000.

  • While sp_monitorconfig  "number of open objects" output shows most or all objects used up and a value > 0 in Reuse_cnt column:

Name                             Num_free  Num_active  Pct_act   Max_Used  Reuse_cnt
-------------------------------  -------------  ---------------- -----------  --------------- ---------------
number of open objects         3             49997        100          50000        12589


Read more...

Environment

SAP Adaptive Server Enterprise (ASE). Not version specific.

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

"number of open object" , "open objects" , "open object" , Reuse_cnt , sp_monitorconfig , statement cache , enable literal autoparam , light weight procedures , LWP, reuse sql statements, object descriptor, release open objects, disconnect connections , 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.