"Memory Notification: Library Cache Object loaded into SGA" messages in Oracle alert log (Legacy KB ID CNC TS32480 )

Document ID : KB000051743
Last Modified Date : 14/02/2018
Show Technical Document Details
Oracle10g R2 has an undocumented parameter that sets the KGL heap size warning threshold.  
Warnings are written if heap size exceeds this threshold.   
Set  _kgl_large_heap_warning_threshold  zero to prevent these warning messages and the resulting large .trc files.
To set _kgl_large_heap_warning_threshold to 0, 


1. log into sqlplus as as sysdba


SQL> alter system set "_kgl_large_heap_warning_threshold"=0 scope=spfile ;
SQL> show parameter _kgl_large_heap_warning_threshold
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
_kgl_large_heap_warning_threshold integer 0


2. Edit the init parameter file.


Unix:
Edit the ORACLE_HOME/dbs/init{SID}.ora.usr parameter include file and add:
_kgl_large_heap_warning_threshold=0


Windows:
Edit the ORACLE_HOME/database/init{SID}.ora.usr parameter include file and add:
_kgl_large_heap_warning_threshold=0
3. Remove the large .trc files from ORACLE_HOME/admin/udump/{SID} directory.
4. Restart ehealth and Oracle with the commands


nhServer stop
nhStopDb immediate
nhStartDb
nhServer start 



Related Issues/Questions:
"Memory Notification: Library Cache Object loaded into SGA" messages in Oracle alert log
large .trc files filling ORACLE_HOME/admin/udump/{SID}
Heap size 51432K exceeds notification threshold (51200K)
The following messages are reported in ORACLE_HOME/admin/bdump/{SID}/alert_{SID}.log after 10g Release 2 is installed
Memory Notification: Library Cache Object loaded into SGA
Heap size 51556K exceeds notification threshold (51200K)
Details in trace file ORACLE_HOME/admin/udump/{SID}/{sid}_ora_<nnnn>_ehealth.trc

Problem Environment:
All platforms
eHealth version 6.1 or greater installed with Oracle version 10g R2

Causes of this problem:
These are warning messages that should not cause the program responsible for these errors to fail. 
They appear as a result of a new event messaging mechanism and memory manager in 10g Release 2.
The messages do not imply that an ORA-4031 is about to happen.
They can however write large .trc files to the ORACLE_HOME/admin/udump/{SID} directory.

Changes affecting this problem:
eHealth installed with Oracle 10G
During eHealth upgrade, Oracle upgraded from 9i to 10g Release 2

Additional Information:



(Legacy KB ID CNC TS32480 )