Question: Why does my database have the _kgl_large_heap_warning_threshold parameter set?
Answer: The _kgl_large_heap_warning_threshold hidden parameter is used to suppress superfluous warning messages in the Oracle alert log. Also see MOSC 330239.1 on _kgl_large_heap_warning_threshold.
In
10g we have a new undocumented parameter that sets the KGL heap size warning threshold.
This parameter was not present in 10gR1. Warnings are written if heap size exceeds this threshold.
Set _kgl_large_heap_warning_threshold to
a reasonable high value or zero to prevent these warning messages. Value needs to be set in
bytes.
If you want to set this to 8192 (8192 * 1024) and are using an spfile:
(logged in as "/ as sysdba")
SQL> alter system set "_kgl_large_heap_warning_threshold"=8388608
scope=spfile ;
SQL> shutdown immediate SQL> startup
SQL> show parameter _kgl_large_heap_warning_threshold
NAME TYPE VALUE
If using an "old-style" init parameter,
Edit the init parameter file and add
_kgl_large_heap_warning_threshold=8388608