RE: parse/execute ratio
- From: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 2 Mar 2004 09:12:52 -0500
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:
