ORA-600 [723] [memory leak]

ORA-600 [723] [memory leak]

详细的跟踪日志：

…………………………………………
*** 2022-12-27T01:17:26.542463+08:00
ORA-00600: internal error code, arguments: [723], [916320], [16713352], [memory leak], [], [], [], [], [], [], [], []
……………………………………

*** 2022-12-27T01:17:27.851318+08:00
TOC00000 - Table of contents
TOC00001 - Error Stack
TOC00002 - Dump for incident 1684978 (ORA 600 [723])
| TOC00003 - Beginning of Customized Incident Dump(s)
| TOC00004 - Error Stack Dump
| TOC00005 - SQL Statement (None)
| TOC00006 - Call Stack Trace
| TOC00007 - Binary Stack Dump
| TOC00008 - Argument/Register Address Dump
| TOC00009 - Kernel Stack Trace
| TOC00010 - Process Map Dump
| TOC00011 - Process Resource Limits
| TOC00012 - Process State Dump (1)
| TOC00013 - Fixed Areas Dump (level=327)
| | TOC00014 - Dump of the Fixed PGA
| | TOC00015 - Dump of the Fixed Generic PGA
| | TOC00016 - Dump of the Fixed DGA
| | TOC00017 - Dump of the Fixed SGA
| | TOC00018 - Dump of Compile-Time Constants
| | TOC00019 - Dump of the Fixed USGA
| TOC00020 - START Event Driven Actions Dump
| TOC00021 - START DDE Actions Dump
| | TOC00022 - START DDE Action: 'dumpFrameContext' (Sync)
| | | TOC00023 - START Frame Context DUMP
| | TOC00024 - START DDE Action: 'dumpDiagCtx' (Sync)
| | | TOC00025 - Diag Context Dump
| | TOC00026 - START DDE Action: 'dumpBuckets' (Sync)
| | TOC00027 - START DDE Action: 'dumpGeneralConfiguration' (Sync)
| | | TOC00028 - General Configuration
| | TOC00029 - START DDE Action: 'kdlut_bucketdump_action' (Sync)
| | TOC00030 - START DDE Action: 'kzxtDumpAction' (Sync)
| | TOC00031 - START DDE Action: 'dumpKernelDiagState' (Sync)
| | | TOC00032 - Kernel Diag Dump
| | TOC00033 - START DDE Action: 'dumpBucketsRdbms' (Sync)
| | TOC00034 - START DDE Action: 'dumpASMState' (Sync)
| | TOC00035 - START DDE Action: 'DUMP_SWAP' (Sync)
| | TOC00036 - START DDE Action: 'DUMP_PATCH' (Sync)
| | TOC00037 - START DDE Action: 'dumpKSIPCState' (Sync)
| | TOC00038 - START DDE Action: 'dumpKSTBuffers' (Sync)
| | | TOC00039 - Trace Bucket Dump Begin: default bucket for process 0
| | TOC00040 - START DDE Action: 'xdb_dump_buckets' (Sync)
| | TOC00041 - START DDE Action: 'dumpKGERing' (Sync)
| | TOC00042 - START DDE Action: 'dumpKGEIEParms' (Sync)
| | TOC00043 - START DDE Action: 'dumpKGEState' (Sync)
| | TOC00044 - START DDE Action: 'kpuActionDefault' (Sync)

*** 2022-12-27T01:17:27.851336+08:00

参考官方文档：

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可以设置为安全地忽略小的内存泄漏。