Mladen's advice actually covers that. No matter what's causing the slow performance, if something's taking time, then it will show up in the 10046 trace data. "That's why we love her so."
Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Hotsos Clinic 101 in Sydney - Hotsos Symposium 2004, March 7-10 Dallas - Visit www.hotsos.com for schedule details... -----Original Message----- Brian Dunbar Sent: Monday, August 25, 2003 4:44 PM To: Multiple recipients of list ORACLE-L 'Laura' On Monday, August 25, 2003 1:49 PM said; > We currently have an application we are trying to speed up. In > researching rule/cost based optimizers, I read that the cost based > optimizer was the way to go (although rule had its moments) because that > is where Oracle would be focusing any upgrades, enhancements, etc. <snip> > The database is Oracle 8.0.5. This weekend I will be upgrading to > 8.1.7. The operating system is NT 4.0. Does anyone know something that > could point me in the right direction? Thank you for your help. Worth pointing out that a number of things could be slowing your application ... OS, RAM, processor, network connections, time of day and end user perception to name a few. Before diving into the code (so to speak) you did verify that none of the other factors are at work, I'm sure ... ~brian -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Brian Dunbar INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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.net -- Author: Cary Millsap INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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).
