隐含参数 _kgl_large_heap_warning_threshold

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

 

_kgl_large_heap_warning_threshold integer 8388608

 

If using an "old-style" init parameter,

 

Edit the init parameter file and add

 

_kgl_large_heap_warning_threshold=8388608