12c Query Against Dictionary Views slow

Doc ID 1292253.1

SQL> purge recyclebin; --if you have DBA access, purge dba_recyclebin;
SQL> EXEC DBMS_STATS.GATHER_TABLE_STATS(OWNNAME =>'SYS', TABNAME => '$KTFBUE',ESTIMATE_PERCENT=>100);
SQL> EXEC DBMS_STATS.GATHER_SCHEMA_STATS('SYS');
SQL> EXEC DBMS_STATS.GATHER_FIXED_OBJECTS_STATS(NO_INVALIDATE => FALSE);