The application is probably closing the cursor each time instead of leaving
it open, rebinding the bind variables and doing an execute.
Jim
"Joe Bayer" <u705413818_at_spawnkill.ip-mobilphone.net> wrote in message
news:l.1020976343.1212951660@[64.94.198.252]...
> In our database, there are quite some high ratio parse/executions sql,even
though we are already using bind variables.
> here are a few examples
>
> SELECT ROADWAY_ID,ALIAS_CODE,ALIAS
> FROM V_ROADWAY_ALIAS
> WHERE ROADWAY_ID = :b1
> AND METRO_ID = :b2 AND ALIAS_CODE = :b3
> AND ALIAS_LEVEL = :b4
>
> parse 1129, executions 1129
>
> The libray hit ration is 99% and we have fairly big shared_pool,
> could somebody help me?
>
> Your help is highly appreciated.
>
>
>
>
>
>
>
> --
> Sent by joebayerii from hotmail within field com
> This is a spam protected message. Please answer with reference header.
> Posted via http://www.usenet-replayer.com/cgi/content/new
Received on Thu May 09 2002 - 20:27:10 CDT
