查询oracle统计信息是否过期

--刷新数据库监控信息：
begin
dbms_stats.flush_database_monitoring_info;
end;
/

--过期状态查看：stale_stats 状态是否为"YES"
select owner, table_name, object_type, stale_stats, last_analyzed
from dba_tab_statistics
where owner = 'SCOTT'
and table_name = 'TEST';

--过期原因
select table_owner, table_name, inserts, updates, deletes, timestamp
from all_tab_modifications
where TABLE_OWNER = 'SCOTT'
and TABLE_NAME = 'TEST';