RE: tracing makes the sql run faster
- From: John Kanagaraj <john.kanagaraj@xxxxxxx>
- To: "'Prasada.Gunda@xxxxxxxxxxxxxxxx'" <Prasada.Gunda@xxxxxxxxxxxxxxxx>, oracle-l@xxxxxxxxxxxxx
- Date: Tue, 2 Nov 2004 15:08:02 -0800
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
