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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
