Re: statspack report shows low execute to parse%

On 2 Sep 2005 10:44:36 -0700, "clement rajappa" <clement.rajappa_at_gmail.com> wrote:

>These 2 are way below the 100% target. All other readings are between
>97 to 100%.
>What could be the problem that is causing such low value.

Not using bind variables, not using bind variables, and not using bind variables.
Read *any* article by Thomas Kyte, and you will find out all about them. It is his personal hobby horse and rightly so. In the mean time peak in v$sql to see whether you have any statements like
select * from emp where empno = 10
instead of
select * from emp where empno = :b1
in the former case your code is causing the behavior you observe.

--
Sybrand Bakker, Senior Oracle DBA