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!

DBMS_STATS.GATHER_TABLE_STATS causing LAST_DDL_TIME to be updated?

farside41Mar 8 2016 — edited Mar 14 2016

We recently upgrade or Oracle databases from 11gR1 on Unix to 12c on Linux and since the cutover we have found that in some cases when we run DBMS_STATS.GATHER_TABLE_STATS it is causing the LAST_DDL_TIME for the table to get updated which is then causing packages that depend on those tables to become invalid.

Does this sound like expected behavior?  We never saw this on our previous server and I am having trouble finding information on what may be causing this.

Thanks

Jim

This post has been answered by Hemant K Chitale on Mar 10 2016
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 11 2016
Added on Mar 8 2016
19 comments
7,181 views