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!

Suggestion on STATS

baskar.lSep 14 2010 — edited Sep 14 2010

Hi,

DB version is 10.2.0.4. Using this MS DOC id System Statistics: Scaling the System to Improve CBO optimizer (Doc ID 153761.1) , i collected system stats now.
Previous system stats gathered was almost 2 years back for a half an hour interval when DB size was 400gb. Now the db size is 1TB and now collected stats a peak load for a interval of 120 minutes. Have couple of doubts in importing this..

I used

EXECUTE DBMS_STATS.GATHER_SYSTEM_STATS(gathering_mode=>'INTERVAL', interval => 120, stattab => 'mystats', statid => 'DAY', statown => 'SYSTEM');

1.When i import this new stats, is that all my exisiting execution plans wil change?
2.I have exported the present stats..if i import back the previous stats, does previous execution plans will back in place..as before???

thanks,
baskar.l

This post has been answered by Charles Hooper on Sep 14 2010

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 12 2010

Added on Sep 14 2010

#general-database-discussions

13 comments

903 views