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 )