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 11.2.0.4, 11.2.0.3 and 11.2.0.2. This bug has been fixed in versions 12.1.0.1 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.

dbtut
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 *