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: Query CBO Cost - Hints

Re: Query CBO Cost - Hints

From: <bdbafh_at_gmail.com>
Date: 8 Apr 2005 14:20:46 -0700
Message-ID: <1112995246.090664.288030@f14g2000cwb.googlegroups.com> 





Anurag,



Why not run a 10053 trace while executing the statement and observe
what costs the CBO actually comes up with?
Costs across parsings don't necessarily mean anything.



http://www.centrexcc.com/ - papers -


"A Look under the Hood of CBO: The 10053 Event"



-bdbafh
Received on Fri Apr 08 2005 - 16:20:46 CDT












Original text of this message













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