Probably nothing to worry about. Check out Metalink Note 330239.1. Oracle 10g has a new undocumented parameter. In a nutshell do the following.
(logged in as "/ as sysdba")
SQL> alter system set "_kgl_large_heap_warning_threshold"=8388608 scope=spfile ;
SQL> shutdown immediate
SQL> startup
Jerry Whittle
COINS DBA
NCI Information Systems Inc.
jerome.whittle.[Email address protected]
618-622-4145
-----Original Message-----
From: Dariusz Adamiak [mailto:oracledba-ezmlmshield-x64204327.[Email address protected]
Hallo,
oracle 10g 10.2.0.1.0 win2003 platform
no problems from enterprise manager - no error no alert etc.
but i have a lot of messages in alert log
Memory Notification: Library Cache Object loaded into SGA Heap size 2374K exceeds notification threshold (2048K) Details in trace file e:\oracle\product\10.2.0\admin\[SID]\udump\[SID]_ora_4396.trc
KGL object name :select (CASE ...............
what should i do,
maybe i must try more practise with sql code or something with parameters in database or ....
Thank You for help
regards
Darek
----------------------------------------------------
Zobacz największą animowaną komedię roku->"Skok przez Płot"
Nowy film twórców "Shreka" i "Madagaskaru".
Polski dubbing! W kinach od 7 lipca!
http://klik.wp.pl/?adr=www.skokprzezplot.pl&sid=806
Oracle LazyDBA home page