SAP Knowledge Base Article - Preview

2317629 - Sysmon shows higher "Temporary Table Missing" numbers. TF 299 is set. ASE was upgraded to 157sp136 HF1 from 157sp60

Symptom

After upgrading to 157 sp136 HF1 from sp60, sysmon shows higher than usual "Temporary Table Missing" numbers.  The server is configured with Trace Flag 299:

 

Procedure Cache Management        per sec      per xact       count  % of total
---------------------------  ------------  ------------  ----------  ----------
  Procedure Requests              11161.5          11.0     2009066       n/a  
  Procedure Reads from Disk         493.3           0.5       88789       4.4 %
  Procedure Writes to Disk            0.6           0.0         114       0.0 %
  Procedure Removals                986.8           1.0      177626       n/a  
  Procedure Recompilations          486.1           0.5       87505       n/a  
 
  Recompilations Requests:
    Execution Phase                 486.1           0.5       87504     100.0 %
    Compilation Phase                 0.0           0.0           1       0.0 %
    Execute Cursor Execution          0.0           0.0           0       0.0 %
    Redefinition Phase                0.0           0.0           0       0.0 %

  Recompilation Reasons:
    Table Missing                   486.1           0.5       87503       n/a   
    Temporary Table Missing         486.1           0.5       87503       n/a   
    Schema Change                     0.0           0.0           2       n/a  
    Index Change                      0.0           0.0           0       n/a  
    Isolation Level Change            0.0           0.0           0       n/a  
    Permissions Change                0.0           0.0           0       n/a  
    Cursor Permissions Change         0.0           0.0           0       n/a   


Read more...

Environment

SAP Adaptive Server Enterprise (ASE) 157 SP100 and above

Product

SAP Adaptive Server Enterprise 15.7

Keywords

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.