RE: parse/execute ratio
- From: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 2 Mar 2004 14:45:25 -0500
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]
Sent: Tuesday, March 02, 2004 2:30 PM
To: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Bobak, Mark
Sent: Tuesday, March 02, 2004 2:25 PM
To: oracle-l@xxxxxxxxxxxxx
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@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
-----------------------------------------------------------------
----------------------------------------------------------------
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:
