Re: Execute to Parse %:

Brian wrote:
> Thanks for your help; I don't know what I was thinking this morning.
> I thought I learned something new, but really I was confused about the
> 4 different types of parsing.
>
> I was having trouble understanding how it's possible to have a Soft
> Parse % of 99% and Exec to Parse Ratio of 50%. Now I think I
> understand, please correct me if I'm wrong. When the DB runs a sql
> statement, 50% of the time the DB needs to do a soft parse, and 50% of
> the time the DB doesn't parse at all becuase the cursor is being
> reused (give or take 1%).
>
> Holgler: It looks like the first example you posted is showing 10g's
> new auto bulk bind feature.
>

At the risk of admitting ignorance: There is no auto bulk binding mentioned in the 10 PL/SQL Reference, I could not find anything on asktom or metalink, so what are you talking about?

Besides, I merely demonstrated that

a) PL/SQL is doing autobinding
b) PL/SQL is reusing cursors and therefor
c) when code is reusing cursors then there is no unnecessary parsing (1 parse

    many executions)

The same result can be obtained with 9i, 8i, ...

Regards,
Holger Received on Mon Jul 04 2005 - 06:39:06 CDT