Looks like you need to start using bind variables
Your soft parse % is too low
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Seema Singh
Sent: 01 October 2004 16:05
To: oracle-l@xxxxxxxxxxxxx
Subject: STATSPACK
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!=20
http://search.msn.click-url.com/go/onm00200636ave/direct/01/
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
