list tables and when they were last analyzed.sql

on June 23, 2008 at 12:38 pm
Posted In: Oracle DB and SQL performance analysis (Cat)

select substr(owner,1,12) tab_owner,substr(table_name,1,40) tab_name
,last_analyzed
,num_rows
from dba_tables
where owner not like ‘SYS%’
and last_analyzed > sysdate-10
union
select substr(table_owner,1,12) tab_owner,substr(table_name||’ ‘||partition_name,1,40) tab_name
,last_analyzed
,num_rows
from dba_tab_partitions
where table_owner not like ‘SYS%’
and last_analyzed > sysdate-10
/