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: tracing makes the sql run faster

RE: tracing makes the sql run faster

From: John Kanagaraj <john.kanagaraj_at_hds.com>
Date: Tue, 2 Nov 2004 15:08:02 -0800
Message-ID: <76B324258A8BEE46925BA9473321A847014EBC23@ussccem09.hds.com> 





Prasad, 



>Looks like CBO is changing plan during the day when there is a peak

>activity. I am not sure why it changes the plan. I will 

>monitor it tomorrow and posts the findings.




Just another though - You may have collected system stats (new in 9i) during
off peak hours and that is not applicable during peak hours...



John

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


Received on Tue Nov 02 2004 - 17:03:58 CST












Original text of this message













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