DBA_TAB_MODIFICATIONS table does not return any record


In the DBA_TAB_MODIFICATIONS table, change statistics for all changed tables in the database are stored. The same information can also be accessed from the ALL_TAB_MODIFICATIONS table.

Because of the bug related to UNION ALL numbered 13984324, the records are not returned from these tables. The related bug is seen in the databases, and This bug has been fixed in versions and above.

This problem can be fixed by applying a patch to the bug. Also, if we set the value of “_optimizer_join_factorization” parameter to “false” as workaround, the problem will be solved.

You can change the parameter as follows.

Author: dbtut

We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.

Leave a Reply

Your email address will not be published. Required fields are marked *