Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: STATSPACK
Looks like you need to start using bind variables
Your soft parse % is too low
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Seema Singh
Sent: 01 October 2004 16:05
To: oracle-l_at_freelists.org
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
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Oct 01 2004 - 10:45:12 CDT
![]() |
![]() |