RE: Performance Problem

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


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Cary Millsap
  INET: cary.millsap_at_hotsos.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).