Re: RE: parse/execute ratio
- From: <ryan.gaffuri@xxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Tue, 2 Mar 2004 9:17:19 -0500
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@xxxxxxxxxxxxxxx>
> Date: 2004/03/02 Tue AM 09:12:52 EST
> To: <oracle-l@xxxxxxxxxxxxx>
> 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@xxxxxxx [mailto:ryan.gaffuri@xxxxxxx]
> Sent: Tue 3/2/2004 8:59 AM
> To: oracle-l@xxxxxxxxxxxxx
> 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@xxxxxxxxxxxxx
> put 'unsubscribe' in the subject line.
> --
> Archives are at //www.freelists.org/archives/oracle-l/
> FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
>
>
>
>
Other related posts:
