Oracle alert.log is reporting the following warning:
Memory Notification: Library Cache Object loaded into SGA
Heap size 2172K exceeds notification threshold (2048K)
LIBRARY OBJECT HANDLE: handle=c00000041e56a148 mutex=c00000041e56a278(0)
name=select object_name from all_objects where object_name=TOAD_PROFILER and object_type=PACKAGE
This has only started happening since upgrading from a 9i database to a 10gR2 database.
In 10.2.0.1 Oracle introduced a new undocumented parameter that sets the KGL heap size warning threshold. This parameter was not present in 10gR1. Warnings are written to the alert.log if heap size exceeds this threshold. NOTE: The default threshold in 10.2.0.1 is 2M, so these messages could show up frequently in some application environments. Toad module Toad_Profiler has exceeded the heap size threshold and has triggered a warning message in the alert log. This has no effect on Toad, and the Toad user will be unaware that this has occurred.
See Oracle Metalink Note: 330239.1 (https://metalink.oracle.com/) forfull details of this ORACLE issue:
WORKAROUND 1
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
WORKAROUND 2
Upgrade Oracle database to 10.2.0.2 where the default threshold has been increased to 50MB
