Database Install/Upgrade/Opatch (MOSC)

MOSC Banner

Library Cache Object loaded into SGA / ORA-600 [KGL-heap-size-exceeded]

edited Oct 14, 2020 6:17PM in Database Install/Upgrade/Opatch (MOSC) 2 comments

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';

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center