Re: Execute to Parse %:

"Frank van Bortel" <frank.van.bortel_at_gmail.com> wrote in message news:d9uk9m$299$1_at_news2.zwoll1.ov.home.nl...
> Brian wrote:
> > It's just annoying when v$sql has things like:
> >
> > SQL_TEXT
> > PARSE_CALLS EXECUTIONS
> > SELECT * FROM WEB_SESSION WHERE SID = :B1 10410
> > 10410
> >
> > Why? This select statement is invoked once for each web page viewing.
> >
> >
> > Or
> >
> > SQL_TEXT
> > PARSE_CALLS EXECUTIONS
> > SELECT * FROM PATIENT WHERE PATIENT_ID = :B1 3587
> > 3587
> >
>
> Bind variables - good.
>
> > There are lots of sql statements that have the same parse calls as
> > executions. Sure the web application runs nicely (and is making
> > money), however it's a legitimate concern that the execute to parse
> > ratio is low. I would at least like to understand why. Maybe
> > there's nothing that can be done, I would like to understand why.
> > Maybe something can be done. I'm not really sure why.
> >
>
> hard or soft parses? Hard parses should be avoided, soft cannot
> always be avoided (bind variable values do change...)
> If soft - don't worry.
> --
> Regards,
> Frank van Bortel

Soft parses can be avoided.(even if the bind variable changes) Just rebind and execute.
Jim Received on Wed Jun 29 2005 - 22:45:05 CDT