Checking Oracle Table Stats
If you do not run stats on Oracle database the performance degrades over time. The statements below will show the last stats update date/time. You must change the OWNER to match your schema of course.
select min(STATS_UPDATE_TIME) from ALL_TAB_STATS_HISTORY
where OWNER = ‘ADMUSER’
select * from ALL_TAB_STATS_HISTORY
where OWNER = ‘ADMUSER’
order by STATS_UPDATE_TIME ASC