SAP Knowledge Base Article - Preview

2559652 - How to read Pct_act field of sp_monitorconfig - SAP ASE

Symptom

  • How to interpret the Pct_Active field for 'Procedure Cache Size' on sp_monitorconfig?
  • Pocedure cache does not seem to be clearing
  • sp_monitorconfig "procedure cache size" reports high procedure cache usage

 Name                                    Num_free   Num_active  Pct_act     Max_Used    Reuse_cnt   Instance_Name
 -------------------------               -----------      -----------        -------         -----------        -----------      ------------------------------
 procedure cache size            30259        569741         94.96        600000          3806            NULL


Read more...

Environment

SAP Adaptive Server Enterprise (ASE) - All versions

Product

SAP Adaptive Server Enterprise all versions

Keywords

SYBASE, memory , 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.