Re: Execute to Parse %:

Brian wrote:
> I did some more research. A cursor is not parsed when the application
> keeps executing the same cursor over and over aging with the exact same
> values in the bind variables. So the Execute to Parse Ratio is really
> measuring how often the application keeps executing the same SQL
> statement (and getting the exact same results).
>
> Not sure why the target is 100%. A low ratio in my case really means
> users are passing different values to bind variables and querying
> different rows the DB.

Ummm ... well you are at least trying to figure it out but you are still not exactly close.

"A cursor is not parsed when the application keeps executing the same cursor over and over again with the exact same values".

No ... it depends on if the cursor is CLOSED or not before it is re-executed.

How often do you expect that an application would keep executing the same sql with the same value in the bind variables?

Keep reading Bryan but maybe take a break and come back to Tom's book and the same chapters later. Sometimes it just takes a while to sink in. Received on Sat Jul 02 2005 - 13:08:50 CDT