Questions about data not being queried in the dba_tab_modifications data dictionary

A customer request was received today, when the customer looked up the data dictionary and found the following phenomenon.

Sql> Select table_name from dba_tab_modifications where table_name= ' stat_table ';

No rows selected

Sql> Select table_name from dba_tab_modifications where table_name like '%stat_table ';

table_name

--------------------------------------------------------------------------------

Stat_table

Stat_table

After checking in MoS, find the following error. It turns out that this is a mistake for Oracle.

Bug 13984324-wrong result with UNION all of similar queries/in dba_tab_modifications (Doc ID 13984324.8)

Error occurred in version: 11.2.0.4

11.2.0.3

11.2.0.2

Bug-resolved version: 12.1.0.1

Other Workarounds:

"_optimizer_join_factorization" =false

Sql> alter session Set "_optimizer_join_factorization" = false;

Sql> Select table_name from dba_tab_modifications where table_name like ' stat_table ';

table_name

--------------------------------------------------------------------------------

Stat_table

Stat_table