Memory Notification: Library Cache Object loaded into SGA

Memory Notification: Library Cache Object loaded into SGA

Just a warning is found in my alert log file.

As below:

Memory Notification: Library Cache Object loaded into SGA Heap size 2250K exceeds notification threshold (2048K) Details in trace file /u01/oracle/admin/sample/udump/sample_ora_16462.trc KGL object name :XDB.XD+s5hmkr05krgMFeMBRYQnQ==

The database version is

SQL> select * from v$version;   BANNER ---------------------------------------------------------------- Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod PL/SQL Release 10.2.0.1.0 - Production CORE    10.2.0.1.0      Production TNS for Linux: Version 10.2.0.1.0 - Production NLSRTL Version 10.2.0.1.0 - Production

At first, this message is not a error but a warning. You can see the note 330239.1 at Metalink.

It maybe take long time to find the spare memory. But nothing is found. So extend the momeory to get it. It's caused by more fragment in SGA probably.

Solution；

You can add the implicit parameter '_kgl_large_heap_warning_threshold ' and set its value a big number, for exmaple 10M. And this issue is fixed in 10.2.0.2 by modify the default values to be 50M.

in 10.2.0.1.

step 1

SQL>alter system set " _kgl_large_heap_warning_threshold "=10240000 scope=spfile;

or

SQL> create pfile=’/home/oracle/init.ora' from spfile;

then add _kgl_large_heap_warning_threshold =10240000 into it

echo _kgl_large_heap_warning_threshold =10240000 >> /home/oracle/init.ora

step 2

restart the instance;

版权声明：本文内容由网络用户投稿，版权归原作者所有，本站不拥有其著作权，亦不承担相应法律责任。如果您发现本站中有涉嫌抄袭或描述失实的内容，请联系我们jiasou666@gmail.com 处理，核实后本网站将在24小时内删除侵权内容。