Oracle In place Upgrade 12c to 19c – After successful upgrade do below to avoid error ORA-00600: internal error code, arguments during query execution
SPOOL collect_dictionary_stats.log
set time on;
set feedback on;
select sysdate from dual;
set echo on feedback on time on timing on verify on
show con_name;
SET VERIFY OFF
set pages 500 line 200
EXEC DBMS_STATS.GATHER_FIXED_OBJECTS_STATS ();
EXEC DBMS_STATS.GATHER_SCHEMA_STATS(‘SYSTEM’);
EXEC DBMS_STATS.GATHER_SCHEMA_STATS(‘SYS’);
EXEC DBMS_STATS.GATHER_DICTIONARY_STATS ();
select sysdate from dual;
SPOOL OFF
EXIT;
EOF
#