Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Gether statistic does not take effect immidiately

Aacc-OracleOct 24 2008 — edited Oct 26 2008

Sometimes queries vary slow due to the statistic not up-to-date. this usually solved by gether statistic using DBMS_STATS.GATHER_SCHEMA_STATS.
However, I noticed that I have to execute this few times or maybe I have wait for a moment to see query back to normal performance.

Is this happen beacuse of the query plan was cached? or any other reason? how can I make updated statistic take effect immidiately.

Thanks

This post has been answered by 448778 on Oct 25 2008

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 23 2008

Added on Oct 24 2008

#general-database-discussions

24 comments

3,586 views