Re: Execute to Parse %:

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