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!

List of non-analyzed tables

762809Dec 1 2010 — edited Dec 7 2010

Hi Friends,

I know that tables which are not analyzed(compute stats) can cause performance degradation.
How do I select all the tables in our database which were not analyzed ( compute statistics) eversince?
How do select all the tables in our database which were not analyzed ( compute statistics) for the past 1 month or more?
How do I create a script that will analyze the selected tables above?

Thanks a lot

MsK

This post has been answered by 726742 on Dec 1 2010

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 4 2011

Added on Dec 1 2010

#general-database-discussions, #oracle

31 comments

4,296 views