Re: Help: How do you reduce the parse/executions ratio?

Well, as obvious as it sounds, to get the parses down you need to parse less. It's the applications that initiate the parses (often explicitly). This sample cursor presumably isn't from a pl/sql object (unless it's dynamic sql) since it would only have parsed when the object was loaded into memory. Unless, the object is getting pushed in and out of memory repeatedly (maybe running out of shared pool?). At least with binds, they are just doing a string match (hashed?) on the query and using the cached cursor for the execution. That's not nearly as bad as having to 'really' parse the query.

Richard

Joe Bayer wrote:
>
> 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 - 16:31:41 CDT