How can I determine whether Oracle DDIC tables contain statistics?
You can use the following SELECT statement to determine whether and which objects from the Oracle data dictionary contain statistics: SELECT TABLE_NAME FROM DBA_TABLES WHERE LAST_ANALYZED IS NOT NULL AND OWNER = ‘SYS’; Note 138639 describes the cases in which you should create statistics for the Oracle DDIC.
Related Questions
- If the query returns X$ tables, then fixed object statistics exist.17. Why do some tables not contain any new statistics even though a statistical run was carried out with BRCONNECT?
- Why do some tables not contain any new statistics even though a statistical run was carried out with BRCONNECT?
- How can I determine tables whose statistics have too low a sample size?
