Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: tracing makes the sql run faster
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-lReceived on Tue Nov 02 2004 - 17:03:58 CST
![]() |
![]() |