Heap size 2498K exceeds notification threshold (2048K) 问题处理

一朋友的库告警经常性报Heap size exceeds
下面是症状：

点击(此处)折叠或打开

1. Heap size 2498K exceeds notification threshold (2048K)
2. LIBRARY OBJECT HANDLE: handle=dec9e9c8 mutex=00000002DEC9EAF8(0)
3. name=
4. select a.eid,a.eid,a.bid,a.bid,a.iid,a.iid,A.SUMMARY,A.SUMMARY,A.BUDGETMONEYCONTROL,A.BUDGETMONEYCONTROL,A.BUDGETPAYTYPE,A.BUDGETPAYTYPE,a.MONEY,(SELECT SUM(C.MONEY+nvl(C.FIRST_MONEY,0)) AS MONEY FROM BUDGET C WHERE C.SETID=1 AND C.YEAR=2013 and C.AUDITSTATUS=-2 AND length(C.DOWNUSER)>0 AND C.BUDGETMONEYCONTROL IN (-1,0,5,6,7) AND 1=1 AND C.CONTROLTYPE IN (\'001\') AND C.B_TYPE IN (0,2,4,5) AND (C.DOWN_DATE>=\'2013-01-01\' AND C.DOWN_DATE<=\'2013-12-31\') and (c.b_exe_id=a.b_exe_id or c.source_id=a.b_exe_i
5. hash=2137e19abd800cae3d6102b647bee84f timestamp=01-03-2014 14:01:37
6. namespace=CRSR flags=RON/KGHP/TIM/KEP/PN0/DBN/[10010044]
7. kkkk-dddd-llll=0001-0001-0001 lock=N pin=0 latch#=8 hpc=0002 hlc=0002
8. lwt=00000002DEC9EA70[00000002DEC9EA70,00000002DEC9EA70] ltm=00000002DEC9EA80[00000002DEC9EA80,00000002DEC9EA80]
9. pwt=00000002DEC9EA38[00000002DEC9EA38,00000002DEC9EA38] ptm=00000002DEC9EA48[00000002DEC9EA48,00000002DEC9EA48]
10. ref=00000002DEC9EAA0[00000002DEC9EAA0,00000002DEC9EAA0] lnd=00000002DEC9EAB8[000000019C2E1E08,00000002DECDC7C8]
11. LIBRARY OBJECT: object=713cd6a8

解决方法：

点击(此处)折叠或打开

1. SQL> select * from v$version;
   
2. 
   
3. BANNER
   
4. ----------------------------------------------------------------
   
5. Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
   
6. PL/SQL Release 10.2.0.1.0 - Production
   
7. CORE 10.2.0.1.0 Production
   
8. TNS for Linux: Version 10.2.0.1.0 - Production
   
9. NLSRTL Version 10.2.0.1.0 - Production
   
10. 
    
11. SQL> SELECT ksppinm, ksppstvl, ksppdesc
    
12.   2 FROM x$ksppi x, x$ksppcv y
    
13.   3 WHERE x.indx = y.indx AND ksppinm = '_kgl_large_heap_warning_threshold';
    
14. 
    
15. KSPPINM
    
16. --------------------------------------------------------------------------------
    
17. KSPPSTVL
    
18. --------------------------------------------------------------------------------
    
19. KSPPDESC
    
20. --------------------------------------------------------------------------------
    
21. _kgl_large_heap_warning_threshold
    
22. 2097152
    
23. maximum heap size before KGL writes warnings to the alert log --10.2.0.1 是2m 10.2.0.2是50m
    
24. 
    
25. 
    
26. _kgl_large_heap_warning_threshold    _kgl_large_heap_warning_threshold        52428800    52428800            maximum heap size before KGL writes warnings to the alert log

可修改隐藏参数消除告警里面的信息。

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/29477587/viewspace-1078563/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/29477587/viewspace-1078563/