Re: parse_calls/executions ratio

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.

Thanks

--
LSC



On Mon, Mar 9, 2009 at 10:12 PM, William Wagman <wjwagman_at_ucdavis.edu>wrote:



> Greeting,

>

> 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 >

> 2.

>

> 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?

>

> Thanks.

>

> Bill Wagman

> Univ. of California at Davis

> IET Campus Data Center

> wjwagman_at_ucdavis.edu

> (530) 754-6208

>

> --

> http://www.freelists.org/webpage/oracle-l

>

>

>


--
http://www.freelists.org/webpage/oracle-l