ORA-600 [723] [memory leak]

ORA-600 [723] [memory leak]

故障诊断：
1，在报600错误之前，告警日志一直在报错表空间不足不能扩展(数据库有导入数据操作)；
2，ORA600告警在09:36分到09:37分，持续1分钟，时间点前后未出现告警；
3，判断是因为导入数据时，表空间不足不能扩展，导致导入数据失败，在注销会话是PGA检查时发现此错误；
4，此次PGA内存泄漏(684k - 1.6M)较轻，不会导致数据损坏，并且后续没有告警，可以忽略

告警日志：

See Note 411.1 at My Oracle Support for error and packaging details.
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
DIA-48001: internal error code, arguments: [dbgrdr_2], [5], [7], [orcl2_ora_95129.trc], [1], [1], [515], [512]
2021-03-24T09:37:05.761840+08:00
Errors in file /oracle/app/diag/rdbms/orcl/orcl2/incident/incdir_1548058/orcl2_ora_95109_i1548058.trc:
ORA-00600: internal error code, arguments: [723], [700440], [1671312], [memory leak], [], [], [], [], [], [], [], []
Errors in file /oracle/app/diag/rdbms/orcl/orcl2/trace/orcl2_ora_95109.trc (incident=1548059):
ORA-00600: internal error code, arguments: [907], [], [], [], [], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [723], [700440], [1671312], [memory leak], [], [], [], [], [], [], [], []
Incident details in: /oracle/app/diag/rdbms/orcl/orcl2/incident/incdir_1548059/orcl2_ora_95109_i1548059.trc
2021-03-24T09:37:06.643258+08:00
Errors in file /oracle/app/diag/rdbms/orcl/orcl2/incident/incdir_1548059/orcl2_ora_95109_i1548059.trc:
ORA-00600: internal error code, arguments: [907], [], [], [], [], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [723], [700440], [1671312], [memory leak], [], [], [], [], [], [], [], []
2021-03-24T09:37:07.564338+08:00
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Use ADRCI or Support Workbench to package the incident.

– 参考官方文档：
ORA-600 [723] “PGA memory leak” (Doc ID 39308.1)

PURPOSE:
  This article discusses the internal error "ORA-600 [723]", what 
  it means and possible actions. The information here is only applicable 
  to the versions listed and is provided only for guidance.
 
ERROR:
  Format: ORA-600 [723] [a] [b] [c]
VERSIONS:           
  versions 6.0 and later
 
DESCRIPTION:

  There is a memory leak in the Program Global Area (PGA)
  The PGA is checked for Space Leaks at logoff time. This error is reported when a leak was found.
  There is no data corruption with this error.
  注销时检查PGA是否有内存泄漏。发现泄漏时会报告此错误。此错误不会导致数据损坏。

ARGUMENTS: There are two formats for this error.

Two Argument format:

  Arg [a] Logoff PGA size in bytes
  Arg [b] Text related to the leak. Typically "memory leak"

Three Argument format:

  Arg [a] Minimum acceptable leak (This indicates that EVENT 10262 is already active)
  Arg [b] Logoff PGA size in bytes  (This value should be > Arg [a] - however, see Note below)
  Arg [c] "memory leak"

  Note: Due to a bug, before Oracle 11gR1, Arg [a] and Arg [b] were reported as being the same value.
 
FUNCTIONALITY:      
  MEMORY COMPONENT
 
IMPACT:             
  PROCESS FAILURE - but only during session delete so impact is minimal 但仅在会话删除期间，因此影响最小
  NON CORRUPTIVE - No underlying data corruption. 没有数据损坏
 
SUGGESTIONS:

  Event 10262 can be set to safely ignore small memory leaks.
  Set the following event in the init.ora file to disable, for example, space leaks less than 4000 bytes:
        event = "10262 trace name context forever, level 4000"
        
  Then stop and restart the database.
  Repeated errors can be diagnosed further by sending the alert.log and trace files to Oracle Support Services.
  Known Issues:
  事件10262可以设置为安全地忽略小的内存泄漏。