Library Cache Object loaded into SGA / ORA-600 [KGL-heap-size-exceeded]
Hi, I am trying to update from Oracle 12c to Oracle 19c. During post upgrade phase, I am getting error below in alert log file and it is getting stuck, not progressing post upgradation
Library Cache Object loaded into SGA / ORA-600 [KGL-heap-size-exceeded]
I followed Doc ID 330239.1 which says by default in both oracle 12c and 19c
_kgl_large_heap_warning_threshold
maximum heap size before KGL writes warnings to the alert log
52428800
_kgl_large_heap_assert_threshold
maximum heap size before KGL raises an internal error
524288000
and it has to be increased to 83886080 and 838860800 using following query..
execute immediate 'alter system set "_kgl_large_heap_warning_threshold"=83886080 scope=spfile';