RE: Performance Problem

'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: Brian.Dunbar_at_Plexus.com

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: 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).