How can I check the last time stats was run on Oracle without using OEM

概述All of the following data dictionary tables have a LAST_ANALYZED column (replace * with USER/ALL/DBA as appropriate: *_TABLES *_TAB_PARTITIONS *_TAB_SUBPARTITIONS *_INDEXES *_IND_PARTITIONS *_IND_SUBP

All of the following data dictionary tables have a LAST_ANALYZED column (replace * with USER/ALL/DBA as appropriate:

*_tableS *_TAB_PARTITIONS *_TAB_SUBPARTITIONS *_INDEXES *_IND_PARTITIONS *_IND_SUBPARTITIONS

(There‘s lots more in the histograms fIElds,but I‘m not going that deep.)

Conversely, ALL_TAB_MODIFICATIONS shows rows inserted/updated/deleted (or the timestamp on which a table/partition/subpartition was truncated) since it had optimizer statistics gathered.

总结

以上是内存溢出为你收集整理的How can I check the last time stats was run on Oracle without using OEM全部内容，希望文章能够帮你解决How can I check the last time stats was run on Oracle without using OEM所遇到的程序开发问题。

如果觉得内存溢出网站内容还不错，欢迎将内存溢出网站推荐给程序员好友。