Wednesday, February 6, 2019

Find the tables with stale stats

SELECT OWNER,
  TABLE_NAME,
  PARTITION_NAME,
  SUBPARTITION_NAME,
  NUM_ROWS,
  LAST_ANALYZED
FROM dba_TAB_STATISTICS
WHERE STALE_STATS='YES';

No comments:

Post a Comment