Checking Oracle Table Stats

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

Comments are closed.