Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

For indexes, replace DBA_TABLES with DBA_INDEXES and TABLE_NAME with INDEX_NAME in the statement above.15. How can I determine whether Oracle DDIC tables contain statistics?

April 26, 2017determine indexes Oracle replace table_name

0

Posted

For indexes, replace DBA_TABLES with DBA_INDEXES and TABLE_NAME with INDEX_NAME in the statement above.15. How can I determine whether Oracle DDIC tables contain statistics?

1 Answer

0

Posted

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’;