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!

dbms_stats.gather_table_stats questions

631607Apr 1 2008 — edited Apr 2 2008

Dear Friends,

I have two questions regarding the use of dbms_stats.gather_table_stats:

(1) How to use dbms_stats.gather_table_stats to calculate statistics for ALL tables of a specific schema?
(2) How to use dbms_stats.gather_table_stats to calculate statistics for a schema's tables with table names starting with AB?

Thanks in advance for your help!

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 30 2008

Added on Apr 1 2008

#general-database-discussions

5 comments

733 views