Ian, what type of optimizer do you use?
Regards, Ed ----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, December 06, 2001 8:50 AM > 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). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Edward Shevtsov 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).
