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 2250 K exceeds notification threshold (2048 K)
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 10 M. and this issue is fixed in 10.2.0.2 by modify the default values to be 50 m.

 

In 10.2.0.1.

 

Step 1

SQL> alter system set"_ Kgl_large_heap_warning_threshold


& Quot; = 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;

 

 

 

*********************************** *****

 

ORA-27102: out of memory solution instance

Oracle performance optimization: Drop table and DB Cache

Implementation Solutions of various cache mechanisms in Java