Skip to Main Content

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!

Verifying dbms_stats.gather_schema_stats package

rg2Feb 13 2008 — edited Mar 28 2012
We just ran the dbms_stats.gather_schema_stats package against a schema and we wanted to see if it ran successfully. Is there a view where we can see if the schema was analyzed and what date as well...something like a last analyzed date. I think DBA_TAB_COLUMNS has something similar,
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 25 2012
Added on Feb 13 2008
29 comments
5,026 views