Parsing count way to high

From: Biddell, Ian <Ian.Biddell_at_compaq.com>
Date: Wed, 05 Dec 2001 22:15:06 -0800
Message-ID: <F001.003D657E.20011205215017@fatcity.com>

Hi all,

Just wondering if any one can help me here, I have an online server that has a number of services within it, just lots of Objects.

But the response time is not what it should and after tracing it I got this:

OVERALL TOTALS FOR ALL NON-RECURSIVE STATEMENTS call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ----------

Parse 878 53.85 53.66 0 0 0 0
Execute 10025 4.54 4.90 3 501 14806 9854
Fetch 9694 55.90 57.32 108 398540 0 9481
------- ------ -------- ---------- ---------- ---------- ----------

total 20597 114.29 115.88 111 399041 14806 19335

So my Parse count is way to high, should be insignificant I would have thought.
So I increased the maxopencursors and recompiled everything that makes up the server (.exe)

But no joy. Is there something else I can look at or do?

Thanks
Ian
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Biddell, Ian
INET: Ian.Biddell_at_compaq.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


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

To REMOVE yourself from this mailing list, send an E-Mail message

to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Thu Dec 06 2001 - 00:15:06 CST