Heap size 2498K exceeds notification threshold (2048K) 問題處理

yewushang發表於2014-02-09

一朋友的庫告警經常性報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;

  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

  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';

  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


  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/，如需轉載，請註明出處，否則將追究法律責任。

相關文章