Friday, July 20, 2018

List oracle tables with stale stats


SQL> set pagesize 500 linesize 200
SQL> select owner, table_name, num_rows from dba_tab_statistics where stale_stats = 'YES' order by owner, table_name;

No comments: