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
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.