Instance Efficeincy Percentag
460592Feb 28 2008 — edited Feb 29 2008Hi All,
Here is my statspack report for Instance Efficiency Percentages runing in peak time:
Instance Efficiency Percentages (Target 100%)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Buffer Nowait %: 100.00 Redo NoWait %: 100.00
Buffer Hit %: 69.53 In-memory Sort %: 100.00
Library Hit %: 89.62 Soft Parse %: 72.60
Execute to Parse %: 74.11 Latch Hit %: 100.00
Parse CPU to Parse Elapsd %: 40.00 % Non-Parse CPU: 99.73
any recommend site or book or even you advice for tuning performance?
TIA,
Lux
Message was edited by:
lux