Recently Analyzed Tables

 

Recently Analyzed Tables

LAST ANALYZED TABLE NOTES:

Owner - Owner of the table

Table Name - Name of the table

Last Analyzed - Last analyzed date/time

select  OWNER,
 TABLE_NAME,
 to_char(LAST_ANALYZED,'MM/DD/YYYY HH24:MI:SS') last_analyzed
from  dba_tab_columns
where  OWNER not in ('SYS','SYSTEM')
and  LAST_ANALYZED is not null
and COLUMN_ID=1
and  (SYSDATE-LAST_ANALYZED) < 30
order by (SYSDATE-LAST_ANALYZED)