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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Help, I am desperate: Sql problems or a bug

Re: Help, I am desperate: Sql problems or a bug

From: David Russell <user_at_msn.com>
Date: 1997/12/09
Message-ID: <01bd04de$2acbebe0$ab4195c1@thor>#1/1 







Assuming that you are still running on the same machine and everything else
is equal, I suspect the problem is either optimizer releated or you now
have different buffer cache setting. Check you are using the same optimizer
mode and if you are using the cost based optimizer you have the stats
estimated > 10%. For further analysis you should compare the explain plans
from 7.3.2 to 7.3.3.



Regards


David Russell 
Received on Tue Dec 09 1997 - 00:00:00 CST












Original text of this message













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