DBA Scripts & knowledge....!
....there is no such thing as failure, only learning experiences.
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment