11_Table_Analyzed.sql

11_Table_Analyzed.sql

select OWNER,TABLE_NAME,to_char(LAST_ANALYZED,'DD/MON/YYYY-HH24:mi')

from dba_tables

where owner = '&OWNER'

order by LAST_ANALYZED DESC         

/