Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
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.
1 | SQL > alter system set "_optimizer_join_factorization"=false scope=both sid='*'; |
