REM  #*****************************************************
REM  # File Name: last_analyze.sql
REM  #
REM  # Purpose: Report the last time objects were analyzed.
REM  #
REM  #*****************************************************

select   table_name,
	 column_name, 
         to_char(max(last_analyzed), 'dd-Mon-yyyy hh24:mi') youngest,
         to_char(min(last_analyzed), 'dd-Mon-yyyy hh24:mi') oldest
from     sys.dba_tab_columns  
where    (last_analyzed is not null) AND
         (owner != 'SYS')
group by table_name, column_name;