Oracle RDBMS version: 9.2.0.6
Operating System version : Solaris 5.9
In 10g and 11g , I can use the following query to check if a table's stats have become stale. But, in 9i DBs , there is no DBA_TAB_STATISTICS view. So, how can I check table's stats have become stale as a result of table's data changing x% ?
select SAMPLE_SIZE, STALE_STATS, LAST_ANALYZED from DBA_TAB_STATISTICS where table_name= 'EMP' and owner = 'SCOTT';
SAMPLE_SIZE STALE_STATS LAST_ANALYZED
------------- ------------ ----------------
12068631 NO 26-10-2016 23:25