How can I check the last time stats was run on Oracle withou

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.

（编辑：新余站长网）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!