SAP Knowledge Base Article - Preview

2988719 - monCachedProcedures not reporting cached procedures - ASE

Symptom

  • sp_configure "enable monitoring", 1
  • querying monCachedProcedure does not show stored procedure
  • Enable auditing for stored procedure shows procedure has been executed in the audit tables.
  • dbcc procbufs show: The following states that plan is cached and should show in monCachedProcedures

PROC_HDRs:
Memory usage for all PROC_HDRs starting at 0x1045af7d800
--------------------------------------------------------
PROC_HDR at 0x1045af7d800
p_hdrstep=0x0 p_hdrseq=0x1045af866e8 p_hdrcrt=0x0
p_hdrpbuf=0x10301ad8178 p_hdrtmps=0x1045afb73a0 p_hdrcaller=0x10462cb9800
p_hdrelease=12500 p_hdrtabid=2064218604 p_hdrsub=0x0
p_hdrsubcnt=0 p_css=0x0 p_csscnt=0
p_hdrstatus=413 ((0x00000400 (SACREATED), 0x00000010 (UCTEMPDB_USED), 0x00000002 (64BIT), 0x00000001 (CACHED)))

and

pbstate=1
pbtype=4

 


Read more...

Environment

SAP Adaptive Server Enterprise (ASE) All Versions

Product

SAP Adaptive Server Enterprise all versions

Keywords

procedure cache, monCachedProcedures , 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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.