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!

10 g How to Perform Analysis/Statistics Update on All Tables ?

632013Jul 20 2010 — edited Jul 21 2010

hi all,

The tables in this 10.2 g db have not been analyzed since 2007. Sad but true. That's what the Last Analyzed column shows in Enterprise Manager Console.

Statistics_Level has been set to TYPICAL for several months.

How can I "force" every table to have it's stats updated? When i ran Analyze table abcdef I got "invalid command".

Thanks for any help.

John

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 18 2010

Added on Jul 20 2010

#general-database-discussions

8 comments

1,461 views