Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: tracing makes the sql run faster
if you do not analyze your tables or your stats are out-dated the moon can change query plans.
also, does setting trace on force the CBO to run and you could be defaulting to the RBO(I can't remember if this does it or not... I don't think so).
> Hello All,
>
> We have an application which uses Oracle Forms 6i. One particular query
> takes very long time when it runs in the forms application. When I trace
> the user session to see what was going on, surprisingly query runs much
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Nov 01 2004 - 14:53:08 CST
![]() |
![]() |