ok you lost me. soft parses get listed as parse_calls. How do we find out if there is only a soft parse and no hard parse?
>
> From: "Bobak, Mark" <Mark.Bobak_at_il.proquest.com>
> Date: 2004/03/02 Tue AM 09:12:52 EST
> To: <oracle-l_at_freelists.org>
> Subject: RE: parse/execute ratio
>
> Yes, that would be the ideal situation.
>
> But, don't forget, lots of apps will do one parse per execute.
> They will be soft parses, and perhaps even session cache cursor hits,
> but they still get counted as parses (or PARSE_CALLS).
>
> I'd say any child cursors whose EXECUTIONS is >1 and increasing is being
> reused.
>
> Hope that helps,
>
> -Mark
>
>
> -----Original Message-----
> From: ryan.gaffuri_at_cox.net [mailto:ryan.gaffuri_at_cox.net]
> Sent: Tue 3/2/2004 8:59 AM
> To: oracle-l_at_freelists.org
> Cc:
> Subject: parse/execute ratio
> To see if a query is being reused i can go to v$sql and look at parse_calls to executions right? parse_calls should be low and executions high?
>
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
>
>
>
>
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
To unsubscribe send email to: oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Received on Tue Mar 02 2004 - 08:14:18 CST
