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

标题: ORA-00600；ORA-03135 [打印本页]

作者: Inkcup 时间: 2026-4-19 19:02
标题: ORA-00600；ORA-03135
*** 2026-04-14 08:00:21.612
DDE: Flood control is not active
Incident 404618 created, dump file: E:\APP\ADMINISTRATOR\diag\rdbms\emr\emr\incident\incdir_404618\emr_ora_20832_i404618.trc
ORA-00600: internal error code, arguments: [723], [130680], [154120], [memory leak], [], [], [], [], [], [], [], []
ORA-03135: connection lost contact

Dump file E:\APP\ADMINISTRATOR\diag\rdbms\emr\emr\incident\incdir_404618\emr_ora_20832_i404618.trc
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Windows NT Version V6.2
CPU                : 64 - type 8664, 32 Physical Cores
Process Affinity : 0x0x0000000000000000
Memory (Avail/Total): Ph:166604M/262037M, Ph+PgF:193525M/287637M
Instance name: emr
Redo thread mounted by this instance: 0 <none>
Oracle process number: 0
Windows thread id: 20832, image: ORACLE.EXE (SHAD)

*** 2026-04-14 08:00:22.231
Dump continued from file: E:\APP\ADMINISTRATOR\diag\rdbms\emr\emr\trace\emr_ora_20832.trc
ORA-00600: internal error code, arguments: [723], [130680], [154120], [memory leak], [], [], [], [], [], [], [], []
ORA-03135: connection lost contact

========= Dump for incident 404618 (ORA 600 [723]) ========

*** 2026-04-14 08:00:23.341
----- Beginning of Customized Incident Dump(s) -----
******** ERROR: PGA memory leak detected 154120 > 130680 ********
========================================

154120 实际检测到的PGA内存泄漏量，单位是字节
130680 Oracle内部设置的阈值，单位是字节

154120 > 130680 泄漏量超过了阈值，所以触发了ORA-00600错误

换算： 130680 / 1024 ≈ 127.6 KB
      154120 字节 ÷ 1024 ≈ 150.5 KB

=========================================
所以，这个错误的核心就是：某个会话在结束时，有大约150KB的PGA内存没有被正确释放，超过了127.6KB的阈值，于是Oracle报了警。

这是个软件bug，对数据库的使用没有影响，可以通过打最新的数据库补丁，或者升级数据库版本进行处理。

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