Re: statspack report shows low execute to parse%

Sybrand Bakker wrote:
> 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.

> Sybrand Bakker, Senior Oracle DBA

Sybrand I am confused.

How can you say that he is not using bind variables from the given information.
The information says that Soft Parse % is more that 97%.

If bind variables were not used then wont' Soft Parse % would be far less than 97% ?

The only thing execute to parse ratio being too low tells us that the system is parsing a lot, that could be normal for a web application with stateless connection for e.g mod_plsql or a j2ee environment which does not use statement caching provided by jdbc 3.0.

I am not saying that this ratio too low is not a problem what I am saying is that we would need more information to determine whether it is a problem or not for example latch contention information on library cache latch and shared pool latch.

thanks
amit Received on Tue Sep 06 2005 - 08:30:28 CDT