ORA 600 [kkpo_rcinfo_defstg:objnotfound] when selecting from a table

Problem:

On a 19.5 DB, When executing a simple select statement against a table, the following internal error pops up:

Analysis:

This bug is mainly associated with the table's histograms, it's commonly happening for newly created tables, it fires when it reads histgrm$ table.
To work it around, it's recommended to gather a fresh table statistics.

SQL>  EXEC DBMS_STATS.GATHER_TABLE_STATS('PF', 'ASC_INGESTION_DATA_LOGS');

PL/SQL procedure successfully completed.

SQL>  SELECT LAST_ANALYZED ,HISTOGRAM from dba_tab_COL_STATISTICS where owner='PF' and table_name='ASC_INGESTION_DATA_LOGS';


LAST_ANALYZED         HISTOGRAM
--------------------                 ---------------
22-Feb-2022 09:55:27         NONE
22-Feb-2022 09:55:27         NONE
22-Feb-2022 09:55:27         NONE
22-Feb-2022 09:55:27         NONE
22-Feb-2022 09:55:27         NONE
22-Feb-2022 09:55:27         NONE

6 rows selected.

Solution:

I've filed bug 32827186 which is currently being worked by Oracle's development team. Until they come up with a bug fix, and as a quick workaround, you can gather fresh statistics on the underlying tables in the query as shown above.