search cancel

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


Article ID: 51743


Updated On:


CA eHealth


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
------------------------------------ ----------- ------------------------------
_kgl_large_heap_warning_threshold integer 0

2. Edit the init parameter file.

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

Edit the ORACLE_HOME/database/init{SID}.ora.usr parameter include file and add:
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
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 )


Component: EHCON