Hi,
Statspack report shows.
Instance Efficiency Percentages (Target 100%)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Buffer Nowait %: 100.00 Redo NoWait %: 99.99
Buffer Hit %: 90.75 In-memory Sort %: 99.95
Library Hit %: 87.93 Soft Parse %: 70.05
Execute to Parse %: 1.34 Latch Hit %: 99.99
Parse CPU to Parse Elapsd %: % Non-Parse CPU:
execute to parse % ratio is too low.How to fix that one?
thanks
-Seema
_________________________________________________________________
Don?t just search. Find. Check out the new MSN Search!
http://search.msn.click-url.com/go/onm00200636ave/direct/01/
--
http://www.freelists.org/webpage/oracle-l
