1、发现alert.log告警
Memory Notification: Library Cache Object loaded into SGA
Heap size 2757K exceeds notification threshold (2048K)
2、用sys查看隐藏参数:
select ksppinm, ksppstvl
from x$ksppcv cv, x$ksppi pi
where cv.indx = pi.indx
and pi.ksppinm like '_kgl_large_heap_warning_threshold%';
3、修改此隐含参数
SQL> alter system set "_kgl_large_heap_warning_threshold"=8388608 scope=spfile;
4、重启Oracle服务器
SQL> shutdown immediate
SQL> startup
原因在于Oracle10.2.0.1的Bug,10.2.0.2已经把这个值修改为50M,升级10.2.0.2到也可解决。
阅读(674) | 评论(0) | 转发(0) |