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