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!

Last_analyzed tables

oradba11Jan 19 2009 — edited Jan 19 2009

I am having 9.2.0.6.0. database.
I want to know when the time is entered in the last_analyzed column of dba_tables view.
we are running pl/sql block for analyzing all tables in database every weekend.
but just now i saw the date in last_analyzed column is one moths before for most of tables but few tables have 2 days before date, when we ran pl/sql block . So why most of tables have one months before date.
can some one put some light on it.
~Rohit Mathur

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 16 2009

Added on Jan 19 2009

#general-database-discussions

5 comments

1,171 views