重庆思庄Oracle、Redhat认证学习论坛

标题: ORA-600[723] (PGA内存泄露) [打印本页]

作者: denglj 时间: 2022-7-13 20:12
标题: ORA-600[723] (PGA内存泄露)

系统：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，

Cause：CTRL-Ccauses an exception to occur, which is an abnormal abort of the spatial query.

此次内存泄漏不是非常频繁，可以忽略.不过也可以通过升级解决该告警.

Oracle提供10262事件来屏蔽这个错误，不过不推荐设置该事件.

拓展文档

Mos[ID 242260.1]

欢迎光临重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/)