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: How to trace the oracle optimizer...

Re: How to trace the oracle optimizer...

From: Daniel Roy <danielroy10_at_hotmail.com>
Date: 3 Apr 2003 16:24:49 -0800
Message-ID: <1b061893.0304031624.61fc089@posting.google.com> 





I should add that event 10053 works only with CBO. If you use RBO
(i.e. optimizer_mode = "rule", or "choose" with the tables not having
statistics), event 10053 doesn't work.



Daniel



> do you mean that you want to see what decisions the optimiser took when

> creating an execution plan ?

> If so, you want to be using event 10053 which will create a trace file

> with details.

> 

> HTH


> 

> Regards,

> Norman.

>

Received on Thu Apr 03 2003 - 18:24:49 CST












Original text of this message













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