When and what's been analyzed

select a.TABLE_NAME, a.PARTITION_NAME, a.SUBPARTITION_NAME, a.NUM_ROWS, a.SAMPLE_SIZE,
a.LAST_ANALYZED, a.STATTYPE_LOCKED, a.STALE_STATS, b.MONITORING, b.TEMPORARY,
c.default_directory_name, round(s.bytes/1024/1024) as Mb
from dba_tab_statistics a, dba_tables b, dba_external_tables c, dba_segments s
where a.owner = '[SCHEMA]'
and (a.owner = b.OWNER and a.TABLE_NAME = b.TABLE_NAME)
and (c.OWNER (+)= a.OWNER and c.TABLE_NAME (+)= a.TABLE_NAME)
and (a.owner = s.owner and a.table_name = s.segment_name)
order by a.LAST_ANALYZED asc;