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.
SAP Knowledge Base Article - Preview