Memory Notification: Library Cache Object loaded into SGA

最新推荐文章于 2024-12-01 23:55:34 发布

iteye_20622

最新推荐文章于 2024-12-01 23:55:34 发布

阅读量67

点赞数

文章标签： Cache Oracle SQL Linux

本文介绍了如何解决Oracle数据库中关于SGA堆大小超过警告阈值的问题，包括查看详细信息、理解警告原因、修改参数设置等步骤。通过调整内存参数，可以避免长时间寻找额外内存的情况，从而提高数据库性能。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

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;

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;