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

Home -> Community -> Usenet -> c.d.o.server -> Re: Optimizer assitance needed

Re: Optimizer assitance needed

From: Sybrand Bakker <gooiditweg_at_sybrandb.verwijderdit.demon.nl>
Date: Wed, 04 Aug 2004 00:12:05 +0200
Message-ID: <aa30h0ljhpvfbp8l1723duliig0km0a5kh@4ax.com> 





On 3 Aug 2004 14:14:50 -0700, industrialstr_at_yahoo.com (Masterhit)
wrote:



>my chief question is what can I

>check to determine why PROD chose the plan it did vs TEST? 

The output of the trace file generated by setting event 10053, level
1.


This will dump CBO's reasoning. Outlines are, however probably a
better way to go.



--
Sybrand Bakker, Senior Oracle DBA


Received on Tue Aug 03 2004 - 17:12:05 CDT












Original text of this message













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