Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: The Oracle 9.2.0.4 Optimizer - are there problems with it?

Re: The Oracle 9.2.0.4 Optimizer - are there problems with it?

From: Daniel Fink <Daniel.Fink_at_Sun.COM>
Date: Fri, 02 Apr 2004 14:49:20 -0700
Message-id: <406DDFE0.4E4B0558@sun.com>


Is the problem the Optimizer or something else? Have you confirmed that the CBO is using different execution plans for the same statement? If the plans are the same, but the execution time is not, your problem is elsewhere. Your read operations could be taking more time, sorts/memory joins could be slower, etc.

Daniel Fink



Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
Received on Fri Apr 02 2004 - 15:45:48 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US