Re: parse_calls/executions ratio
- From: LS Cheng <exriscer@xxxxxxxxx>
- To: wjwagman@xxxxxxxxxxx
- Date: Mon, 9 Mar 2009 23:58:34 +0100
Hello Bill
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@xxxxxxxxxxx>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@xxxxxxxxxxx
> (530) 754-6208
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
Other related posts:
