RE: parse/execute ratio

From: Bobak, Mark <Mark.Bobak_at_il.proquest.com>
Date: Tue, 2 Mar 2004 14:45:25 -0500
Message-ID: <4C9B6FDA0B06FE4DAF5918BBF0AD82CF03B45301@bosmail00.bos.il.pqe>

That's certainly a possibility Raj.....but I like to think about these things a bit and see if I can't think my way through to a solution. Too often, assuming Oracle screwed up (and they certainly do, fairly regularly) can lead to errors or misunderstandings.

-Mark

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

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]
Sent: Tuesday, March 02, 2004 2:30 PM
To: oracle-l_at_freelists.org
Subject: RE: parse/execute ratio

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


-----------------------------------------------------------------

----------------------------------------------------------------

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:42:19 CST