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: Different execution plans for same query with same cost

Re: Different execution plans for same query with same cost

From: <ryan_gaffuri_at_comcast.net>
Date: Thu, 03 Mar 2005 18:08:28 +0000
Message-Id: <030320051808.24597.4227529C000908A6000060152205886360079D9A00000E09A1020E979D@comcast.net> 





you will want to look at a 10053 trace of the two different plans. keep tabs on the parameter settings. something changed. 
maybe parameters, maybe the way you analyzed,data distribution. 


--
http://www.freelists.org/webpage/oracle-l


Received on Thu Mar 03 2005 - 13:19:51 CST












Original text of this message













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