Re: parse_calls/executions ratio
Date: Mon, 9 Mar 2009 23:58:34 +0100
I dont think that is an Oracle issue, I have seen this before in some client server applications made by some tool called Windev and the problem was caused by Windev. I am not sure what was wrong but the developers changed their code the extra parse then went away.
I observed this behaviour tracing several sessions with 10046.
-- LSC On Mon, Mar 9, 2009 at 10:12 PM, William Wagman <wjwagman_at_ucdavis.edu>wrote:Received on Mon Mar 09 2009 - 17:58:34 CDT
> In a two node RAC cluster running Oracle 10.2.0.3.0 on RHEL4 (I haven't
> checked a single node instance) awrrpts are showing a negative execute to
> parse ratio. This implies to me that there are SQL statements being parsed
> but not executed. What I am seeing by looking at v$sql and querying
> parse_calls and executions for sql statements is that for non system users
> (SYS,SYSMAN, etc.) the number of parse_calls is always greater than the
> number of executions, in the majority of cases the parse_calls are 1 more
> than the number of executions and for 5 other statements the difference is >
> Is this to be expected? This implies that a statement is being parsed at
> least once without being executed. Is that necessary for Oracle to determine
> the execution plan or something else? Am I about to learn something here?
> Bill Wagman
> Univ. of California at Davis
> IET Campus Data Center
> (530) 754-6208