Procedure Cache Management per sec per xact count % of total --------------------------- ------------ ------------ ---------- ---------- Procedure Requests 6.6 3.7 33 n/a Procedure Reads from Disk 1.0 0.6 5 15.2% Procedure Writes to Disk 0.4 0.2 2 6.1% Procedure Removals 2.6 1.4 13 n/a Procedure Recompilations 0.8 0.4 4 n/a Recompilations Requests: Execution Phase 0.6 0.3 3 75.0% Compilation Phase 0.2 0.1 1 25.0% Execute Cursor Execution 0.0 0.0 0 0.0% Redefinition Phase 0.0 0.0 0 0.0% Recompilations Reasons: Table Missing 0.6 0.3 3 n/a Temporary Table Missing 0.2 0.1 1 n/a Schema Change 0.0 0.0 0 n/a Index Change 0.0 0.0 0 n/a Isolation Level Change 0.2 0.1 1 n/a Permissions Change 0.0 0.0 0 n/a Cursor Permissions Change 0.0 0.0 0 n/a
