13883183259 023-68037655 咨詢熱線:
當前位置: 主頁 > 關于思莊 > 技術分享 >

ORA-600[723] (PGA內存泄露)

發布時間:2022-08-19
系統:rhel 6.8
數據庫:oracle11.2.0.4
異常描述:在巡檢時發現log文件存在以下告警,ORA-600[723](PGA內存泄露).
Mon Jul11 17:39:41 2022
Errors infile /u01/oracle/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_34745.trc  (incident=500456):
ORA-00600:internal error code, arguments: [723], [133856], [236816], [memory leak], [],[], [], [], [], [], [], []
ORA-03135:connection lost contact
Incidentdetails in:/u01/oracle/app/oracle/diag/rdbms/orcl/orcl/incident/incdir_500456/orcl_ora_34745_i500456.trc
Use ADRCIor Support Workbench to package the incident.
See Note411.1 at My Oracle Support for error and packaging details.
 
incident.trc文件顯示如下:
***2022-07-11 17:39:41.105
Dumpcontinued from file:/u01/oracle/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_34745.trc
ORA-00600:internal error code, arguments: [723], [133856], [236816], [memory leak], [],[], [], [], [], [], [], []
ORA-03135:connection lost contact
 
=========Dump for incident 500456 (ORA 600 [723]) ========
-----Beginning of Customized Incident Dump(s) -----
********ERROR: PGA memory leak detected 236816 > 133856 ********
========================================
SUMMARIZEDMEMORY USAGE FOR THIS PROCESS
----------------------------------------
60812432 bytes, 204 chunks: "freememory               "  
          top uga heap    ds=0xc0d2140  dsprt=(nil)
10836432 bytes, 181 chunks: "freememory               "  
          pga heap        ds=0xc0cc6e0  dsprt=(nil)
   261384 bytes,   1 chunk : "free memory               "  
          top call heap   ds=0xc0d1f20 dsprt=(nil)
   236656 bytes, 302 chunks: "kopolalvoid              "  
          pga heap        ds=0xc0cc6e0  dsprt=(nil)
   197336 bytes,  25 chunks: "permanent memory          "  
          pga heap        ds=0xc0cc6e0  dsprt=(nil)
      736 bytes,   2 chunks: "permanent memory          "  
          top call heap   ds=0xc0d1f20 dsprt=(nil)
      160 bytes,   1 chunk : "heap_kdlipga              "  
          pga heap        ds=0xc0cc6e0  dsprt=(nil)
       80 bytes,   1 chunk : "permanent memory          "  
          top uga heap    ds=0xc0d2140  dsprt=(nil)
 
Mos[DocID 2457941.1]文檔與以上場景類似,此為Bug 28751438,
CauseCTRL-Ccauses an exception to occur, which is an abnormal abort of the spatial query.
此次內存泄漏不是非常頻繁,可以忽略.不過也可以通過升級解決該告警.
Oracle提供10262事件來屏蔽這個錯誤,不過不推薦設置該事件.
拓展文檔
Mos[ID 242260.1]
 
?
聯系我們 重慶思莊科技有限公司
023-68037655
重慶思莊科技有限公司 版權所有? 備案號:渝ICP備12004239號-4

渝公網安備 50010702502184號

<<