RE: parse/execute ratio

From: <oracle-l-bounce_at_freelists.org>
Date: Tue, 2 Mar 2004 14:29:50 -0500
Message-ID: <A186CBDC8B1D61438BC50F1A77E91F73057C1AD5@xchgbrsm1.corp.espn.pvt>

coding error .... perhaps??

Raj

---

Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. select standard_disclaimer from company_requirements; QOTD: Any clod can have facts, having an opinion is an art !

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Bobak, Mark Sent: Tuesday, March 02, 2004 2:25 PM
To: oracle-l_at_freelists.org
Subject: RE: parse/execute ratio

Hmm...hadn't thought of that. I did some quick poking around, and a quick IxOra reference. That seems to be absolutely true.

I did find a few counterexamples, though, I think. If LOADS is hard parses and PARSE_CALLS is total parses, then why do I have rows in V$SQL where LOADS > PARSE_CALLS?

Any thoughts, Tanel? (Or anyone else?)

Hmm....a slightly closer look at those SQLs, and they all seem to be recursive SQL. Not sure what's going on there.

-Mark

---

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 - 13:27:17 CST