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!

Schedule EXEC DBMS_STATS.gather_database_stats;

755678Oct 7 2010 — edited Oct 7 2010

Hi Team,

I am working on a 11106 database on HPUX IA64 platform.
I need to schedule the gathering of statistics as SYS user every weekend (Saturday at 10PM).
The command is -> EXEC DBMS_STATS.gather_database_stats;

How do I do that? One way is to schedule a script in crontab. Is there any other alternative way in doing this? Does 11g collect database statistics automatically?

Please let me know your thoughts!

Thanks!

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 4 2010

Added on Oct 7 2010

#general-database-discussions

6 comments

1,774 views