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.

How can I determine, whether there are any statistics relating to fixed objects?

April 26, 2017determine fixed objects relating statistics

0

Posted

How can I determine, whether there are any statistics relating to fixed objects?

1 Answer

0

Posted

As of Oracle 10g, we recommend that you use fixed object statistics (refer to Note 838725). You can check whether these statistics have been created or not as follows: SELECT TABLE_NAME FROM DBA_TAB_STATISTICS WHERE LAST_ANALYZED IS NOT NULL AND OWNER = ‘SYS’ AND TABLE_NAME LIKE ‘X$%’; If the query returns X$ tables, then fixed object statistics exist.