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;
***相关主题****************************************
Oracle性能优化:drop table与db cache