RE: parse/execute ratio

From: Bobak, Mark <Mark.Bobak_at_il.proquest.com>
Date: Tue, 2 Mar 2004 09:12:52 -0500
Message-ID: <4C9B6FDA0B06FE4DAF5918BBF0AD82CFECFC2B@bosmail00.bos.il.pqe>

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:09:54 CST