Wednesday, February 25, 2015

Oracle : Check last analyzed after gather statistic of schema

select table_name, last_analyzed
from user_tables
order by last_analyzed desc nulls last;
It show all table that has been analyzed with last analyzed date..

No comments:

Post a Comment