A bug found in 22.214.171.124…this occurs when AQ_TM_PROCESSES=0
At the time of this writing MOS didn’t have the information publicly available, I had to open a SR to get the resolution.
The fix is to set the database initialization parameter to a non-zero value and gather fixed object statistics again.
SQL> exec dbms_stats.gather_fixed_objects_stats;
BEGIN dbms_stats.gather_fixed_objects_stats; END;
ERROR at line 1:
ORA-20011: Approximate NDV failed: ORA-01870: the intervals or datetimes are
not mutually comparable
ORA-06512: at “SYS.DBMS_STATS”, line 20508
ORA-06512: at “SYS.DBMS_STATS”, line 20951
ORA-06512: at “SYS.DBMS_STATS”, line 21498
ORA-06512: at line 1